From oracle-l-bounce@freelists.org Tue Jul 20 06:10:55 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6KBAZQ11928 for ; Tue, 20 Jul 2004 06:10:45 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6KBAP611882 for ; Tue, 20 Jul 2004 06:10:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 955E672C537; Tue, 20 Jul 2004 05:49:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08365-53; Tue, 20 Jul 2004 05:49:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id ED71372C569; Tue, 20 Jul 2004 05:49:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 20 Jul 2004 05:48:26 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2AF2E72C507 for ; Tue, 20 Jul 2004 05:48:26 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 08365-10 for ; Tue, 20 Jul 2004 05:48:25 -0500 (EST) Received: from rediffmail.com (unknown [202.54.124.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id ED99072C50B for ; Tue, 20 Jul 2004 05:48:24 -0500 (EST) Received: (qmail 2089 invoked by uid 510); 20 Jul 2004 11:14:12 -0000 Date: 20 Jul 2004 11:14:12 -0000 Message-ID: <20040720111412.2088.qmail@webmail31.rediffmail.com> Received: from unknown (221.191.65.144) by rediffmail.com via HTTP; 20 jul 2004 11:14:10 -0000 MIME-Version: 1.0 From: "Prem Khanna J" To: oracle-l@freelists.org Cc: "Naveen,Nahata(IE10)" Subject: Re[1]:reg APPS standard WHO column ? Content-type: text/plain X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5465 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: premj@rediffmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hi Naveen, >> >>The LAST_UPDATE_LOGIN points to FND_USER.USER_ID >> thanx for ur input. this is what the apps dev. guide says: ---------------------------------------------- LAST_UPDATE_LOGIN NUMBER(15) - Foreign Key to FND_LOGINS - Provides access to information about the operating system login of the user who last updated each row value is : TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ---------------------------------------------- SQL > select USER_ID,LAST_UPDATE_LOGIN,USER_NAME from fnd_user where user_name = 'TEST'; USER_ID LAST_UPDATE_LOGIN ---------- ----------------- 1048 42365 SQL >select LOGIN_ID,USER_ID from fnd_logins where USER_ID = 1048; LOGIN_ID USER_ID ---------- ---------- 22780 1048 36108 1048 36109 1048 36111 1048 and "select TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) from dual" returns null. so what does 42365 in FND_USER.LAST_UPDATE_LOGIN mean ? i'm confused !!! can this be related to any v$ view ? Thanks and Regards, Prem. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------