[Home] [Help]
View: JTF_SOURCES
Product: | JTF - CRM Foundation |
Description: | Same as JTF_SOURCES_ALL table |
Implementation/DBA Data: |
APPS.JTF_SOURCES
|
View Text
SELECT SRC.SOURCE_ID
, SRC.LAST_UPDATE_DATE
, SRC.LAST_UPDATED_BY
, SRC.CREATION_DATE
, SRC.CREATED_BY
, SRC.LAST_UPDATE_LOGIN
, LKP.LOOKUP_CODE
, LKP.LOOKUP_TYPE
, LKP.MEANING
, LKP.ENABLED_FLAG
, LKP.DESCRIPTION
, LKP.START_DATE_ACTIVE
, LKP.END_DATE_ACTIVE
, SRC.RELATED_ID1
, SRC.RELATED_ID2
, SRC.RELATED_ID3
, SRC.RELATED_ID4
, SRC.RELATED_ID5
, SRC.ORG_ID
FROM FND_LOOKUPS LKP
, JTF_SOURCES_ALL SRC
WHERE SRC.LOOKUP_TYPE = LKP.LOOKUP_TYPE
AND SRC.LOOKUP_CODE = LKP.LOOKUP_CODE
Columns
Name |
SOURCE_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
LOOKUP_CODE |
LOOKUP_TYPE |
MEANING |
ENABLED_FLAG |
DESCRIPTION |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
RELATED_ID1 |
RELATED_ID2 |
RELATED_ID3 |
RELATED_ID4 |
RELATED_ID5 |
ORG_ID |