FND Design Data [Home] [Help]

View: POR_CAT_SUPP_DOMAIN_LOV_V

Product: ICX - Oracle iProcurement
Description: View for the display of Supplier Domain LOV on bulk load Options page
Implementation/DBA Data: ViewAPPS.POR_CAT_SUPP_DOMAIN_LOV_V
View Text

SELECT LOOKUP_CODE
, MEANING
, LANGUAGE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE='ICX_CAT_SUPPLIER_DOMAINS'
AND NVL(END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND NVL(START_DATE_ACTIVE
, SYSDATE-1) < SYSDATE
AND NVL(ENABLED_FLAG
, 'Y') <> 'N'

Columns

Name
LOOKUP_CODE
MEANING
LANGUAGE