VIEW: APPS.FIIBV_AP_AP_APPY_CHECK_LCV

Source

View Text - Preformatted

SELECT to_char(ac.check_id)||'-'||to_char(ac.org_id)||'-'|| substrb(edw_instance.get_code,1,40) CHECK_PK, ac.payment_method_lookup_code PAYMENT_METHOD_FK, substrb(edw_instance.get_code,1,40) INSTANCE, to_char(ac.check_number) NAME, to_char(ac.check_number) CHECK_NAME, to_char(ac.check_id) CHECK_ID, ac.bank_account_name BANK_ACCOUNT_NAME, ac.status_lookup_code STATUS_LOOKUP_CODE, ac.last_update_date LAST_UPDATE_DATE, ac.creation_date CREATION_DATE, decode(ac.status_lookup_code,'VOIDED',sysdate,NULL) DELETION_DATE, NULL CHECK_DP, '_df:SQLAP:AP_CHECKS:ac', '_df:SQLAP:Check Address:ac', '_df:SQLAP:ap_gov_detail_checks:ac', '_df:JG:JG_AP_CHECKS:ac' from ap_checks_all ac WHERE ac.status_lookup_code NOT IN ('OVERFLOW','SET UP','SPOILED','UNCONFIRMED SET UP')

View Text - HTML Formatted

SELECT TO_CHAR(AC.CHECK_ID)||'-'||TO_CHAR(AC.ORG_ID)||'-'|| SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) CHECK_PK
, AC.PAYMENT_METHOD_LOOKUP_CODE PAYMENT_METHOD_FK
, SUBSTRB(EDW_INSTANCE.GET_CODE
, 1
, 40) INSTANCE
, TO_CHAR(AC.CHECK_NUMBER) NAME
, TO_CHAR(AC.CHECK_NUMBER) CHECK_NAME
, TO_CHAR(AC.CHECK_ID) CHECK_ID
, AC.BANK_ACCOUNT_NAME BANK_ACCOUNT_NAME
, AC.STATUS_LOOKUP_CODE STATUS_LOOKUP_CODE
, AC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, AC.CREATION_DATE CREATION_DATE
, DECODE(AC.STATUS_LOOKUP_CODE
, 'VOIDED'
, SYSDATE
, NULL) DELETION_DATE
, NULL CHECK_DP
, '_DF:SQLAP:AP_CHECKS:AC'
, '_DF:SQLAP:CHECK ADDRESS:AC'
, '_DF:SQLAP:AP_GOV_DETAIL_CHECKS:AC'
, '_DF:JG:JG_AP_CHECKS:AC'
FROM AP_CHECKS_ALL AC
WHERE AC.STATUS_LOOKUP_CODE NOT IN ('OVERFLOW'
, 'SET UP'
, 'SPOILED'
, 'UNCONFIRMED SET UP')