[Home] [Help]
View: EDW_AP_PAY_TERM_MPV
Product: | FII - Financial Intelligence |
Description: | EDW_AP_PAY_TERM_MPV is the view for data validity on source side. |
Implementation/DBA Data: |
APPS.EDW_AP_PAY_TERM_MPV
|
View Text
SELECT TO_CHAR(TERM_ID)||'-'||'AP-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, LAST_UPDATE_DATE
FROM AP_TERMS
WHERE NVL(ENABLED_FLAG
, 'Y') = 'Y' UNION ALL SELECT TO_CHAR(TERM_ID)||'-'||'AR-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40)
, LAST_UPDATE_DATE
FROM RA_TERMS
Columns