VIEW: APPS.FII_AP_PTRM_PAY_TERM_LCV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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