[Home] [Help]
View: BIL_DIMV_SLS_CHANNELS
View Text
SELECT OL.LOOKUP_CODE
, OL.MEANING
, OL.DESCRIPTION
, OL.ENABLED_FLAG
, OL.START_DATE_ACTIVE
, OL.END_DATE_ACTIVE
, OL.LOOKUP_CODE
, OL.MEANING
FROM OE_LOOKUPS OL
WHERE OL.LOOKUP_TYPE = 'SALES_CHANNEL' UNION ALL (SELECT FL.LOOKUP_CODE CHANNEL_LOOKUP_CODE
, FL.MEANING CHANNEL_MEANING
, FL.DESCRIPTION CHANNEL_DESCRIPTION
, FL.ENABLED_FLAG CHANNEL_ENABLED_FLAG
, FL.START_DATE_ACTIVE CHANNEL_START_DATE_ACTIVE
, FL.END_DATE_ACTIVE CHANNEL_END_DATE_ACTIVE
, FL.LOOKUP_CODE ID
, FL.MEANING VALUE
FROM FND_LOOKUPS FL
WHERE FL.LOOKUP_TYPE = 'BIL_VALUE_TYPE'
AND FL.LOOKUP_CODE = '-999' ) WITH READ ONLY
Columns
Name |
CHANNEL_LOOKUP_CODE |
CHANNEL_MEANING |
CHANNEL_DESCRIPTION |
CHANNEL_ENABLED_FLAG |
CHANNEL_START_DATE_ACTIVE |
CHANNEL_END_DATE_ACTIVE |
ID |
VALUE |