[Home] [Help]
View: EDW_AP_PAY_TERM_MPV
| Product: | FII - Financial Intelligence (Obsolete) |
|---|
| Description: | EDW_AP_PAY_TERM_MPV is the view for data validity on source side. |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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