Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | Not implemented in this database |
SELECT AP.APPLICATION_NAME
, CO.LOOKUP_TYPE
, COTY.LOOKUP_TYPE_MEANING
, CO.LOOKUP_CODE
, CO.MEANING
, '_LA:CO.ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, CO.DESCRIPTION
, CO.START_DATE_ACTIVE
, CO.END_DATE_ACTIVE
, CO.APPLICATION_ID
, CO.CREATION_DATE
, CO.CREATED_BY
, CO.LAST_UPDATE_DATE
, CO.LAST_UPDATED_BY
FROM FND_COMMON_LOOKUP_TYPES COTY
, FND_APPLICATION_VL AP
, FND_COMMON_LOOKUPS CO
WHERE CO.LOOKUP_TYPE = 'CZ_SYSTEM_TYPES'
AND CO.APPLICATION_ID =702
AND CO.APPLICATION_ID = AP.APPLICATION_ID
AND CO.APPLICATION_ID = COTY.APPLICATION_ID
AND CO.LOOKUP_TYPE = COTY.LOOKUP_TYPE WITH READ ONLY