[Home] [Help]
View: FII_AP_PTRM_PAY_TERM_LCV
Product: | FII - Financial Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT TO_CHAR(TERM_ID)||'-'||'AP-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) PAY_TERM_PK
, 'ALL' ALL_FK
, DESCRIPTION DESCRIPTION
, ENABLED_FLAG ENABLED_FLAG
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, NAME NAME
, NAME PAYMENT_TERM
, RANK RANK
, TYPE TERM_TYPE
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, LAST_UPDATE_DATE 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) PAY_TERM_PK
, 'ALL' ALL_FK
, DESCRIPTION DESCRIPTION
, TO_CHAR(NULL) ENABLED_FLAG
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, NAME NAME
, NAME PAYMENT_TERM
, TO_NUMBER(NULL) RANK
, TO_CHAR(NULL) TERM_TYPE
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM RA_TERMS
Columns
Name |
PAY_TERM_PK |
ALL_FK |
DESCRIPTION |
ENABLED_FLAG |
INSTANCE |
NAME |
PAYMENT_TERM |
RANK |
TERM_TYPE |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
LAST_UPDATE_DATE |