View: FIIBV_AP_AP_APPY_CHECK_LCV

Product:	FII - Financial Intelligence
Description:	FIIBV_AP_AP_APPY_CHECK_LCV is the base view for Payment Check level of AP Payment dimension
Implementation/DBA Data:	APPS.FIIBV_AP_AP_APPY_CHECK_LCV

View Text

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')

Columns