[Home] [Help]
View: FIIBV_AR_ARDN_DOC_NUM_LCV
Product: | FII - Financial Intelligence |
Description: | FIIBV_AR_ARDN_DOC_NUM_LCV is the base view for AR Document Number level of AR Document
Number dimension |
Implementation/DBA Data: |
APPS.FIIBV_AR_ARDN_DOC_NUM_LCV
|
View Text
SELECT CT.CUSTOMER_TRX_ID||'-'||SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, 'ALL'
, CT.TRX_NUMBER
, CT.TRX_NUMBER
, CT.TRX_NUMBER
, SUBSTR(EDW_INSTANCE.GET_CODE
, 1
, 40)
, CT.LAST_UPDATE_DATE
, '_DF:AR:RA_CUSTOMER_TRX:CT'
, '_DF:AR:RA_INTERFACE_HEADER:CT'
, '_DF:AR:RA_CUSTOMER_TRX_GOV:CT'
, '_DF:JG:JG_RA_CUSTOMER_TRX:CT' FROM RA_CUSTOMER_TRX_ALL CT
Columns
Name |
DOC_NUM_PK |
ALL_FK |
DOC_NUM_DP |
NAME |
DOCUMENT_NUMBER |
INSTANCE |
LAST_UPDATE_DATE |
"_DF:TRX:_EDW" |
"_DF:HD:_EDW" |
"_DF:GOV:_EDW" |
"_DF:JG:_EDW" |