[Home] [Help]
View: FIIBV_AR_ARTT_CODE_LCV
Product: | FII - Financial Intelligence |
Description: | FIIBV_AR_ARTT_CODE_LCV is the base view for AR Transaction Code level of AR Transaction Type dimension |
Implementation/DBA Data: |
APPS.FIIBV_AR_ARTT_CODE_LCV
|
View Text
SELECT SUBSTR(LOOK.LOOKUP_CODE
, 0
, 20)
, 'ALL'
, LOOK.MEANING
, LOOK.MEANING
, LOOK.DESCRIPTION
, LOOK.MEANING
, LOOK.ENABLED_FLAG
, LOOK.CREATION_DATE
, LOOK.END_DATE_ACTIVE
, LOOK.START_DATE_ACTIVE
, SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, LOOK.LAST_UPDATE_DATE
, '_DF:FND:FND_COMMON_LOOKUPS:FND'
FROM AR_LOOKUPS LOOK
, FND_LOOKUP_VALUES FND
WHERE LOOK.LOOKUP_TYPE = 'INV/CM'
AND LOOK.LOOKUP_CODE <> 'PMT'
AND LOOK.LOOKUP_TYPE=FND.LOOKUP_TYPE
AND LOOK.LOOKUP_CODE=FND.LOOKUP_CODE
AND LOOK.MEANING=FND.MEANING
Columns
Name |
TRX_CODE_PK |
ALL_FK |
TRX_CODE_DP |
NAME |
DESCRIPTION |
TRANSACTION_CODE |
ENABLED_FLAG |
CREATION_DATE |
END_DATE_ACTIVE |
STRT_DATE_ACTIVE |
INSTANCE |
LAST_UPDATE_DATE |
"_DF:FND:_EDW" |