VIEW: APPS.BIM_DIMV_SALES_CHANNELS

Source

View Text - Preformatted

SELECT OEL.LOOKUP_CODE SALES_CHANNEL_CODE , OEL.ENABLED_FLAG ENABLED_FLAG , OEL.START_DATE_ACTIVE START_DATE_ACTIVE , OEL.END_DATE_ACTIVE END_DATE_ACTIVE , OEL.MEANING SALES_CHANNEL_NAME , OEL.DESCRIPTION DESCRIPTION FROM OE_LOOKUPS OEL WHERE LOOKUP_TYPE = 'SALES_CHANNEL' UNION ALL SELECT '-999' , NULL , TO_DATE(NULL) , TO_DATE(NULL) , MEANING , NULL FROM FND_LOOKUPS WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE' AND LOOKUP_CODE = '-999' WITH READ ONLY

View Text - HTML Formatted

SELECT OEL.LOOKUP_CODE SALES_CHANNEL_CODE
, OEL.ENABLED_FLAG ENABLED_FLAG
, OEL.START_DATE_ACTIVE START_DATE_ACTIVE
, OEL.END_DATE_ACTIVE END_DATE_ACTIVE
, OEL.MEANING SALES_CHANNEL_NAME
, OEL.DESCRIPTION DESCRIPTION
FROM OE_LOOKUPS OEL
WHERE LOOKUP_TYPE = 'SALES_CHANNEL' UNION ALL SELECT '-999'
, NULL
, TO_DATE(NULL)
, TO_DATE(NULL)
, MEANING
, NULL
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'BIM_VALUE_TYPE'
AND LOOKUP_CODE = '-999' WITH READ ONLY