VIEW: APPS.IEX_AGING_CNSLD_INV_DETAILS_V

Source

View Text - Preformatted

SELECT DISTINCT CNR.ID CONSOLIDATED_INVOICE_ID, HZCA.PARTY_ID PARTY_ID, APS.CUSTOMER_ID CUST_ACCOUNT_ID, APS.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, AABL.aging_bucket_line_id AGING_BUCKET_LINE_ID, CNR.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER, CNR.AMOUNT CONSOLIDATED_INVOICE_AMOUNT, APS.INVOICE_CURRENCY_CODE CONSOLIDATED_INVOICE_AMOUNT_CC, CNR.DUE_DATE CONSOLIDATED_INVOICE_DUE_DATE, CNR.DATE_CONSOLIDATED DATE_CONSOLIDATED, APS.ORG_ID ORG_ID, HU.NAME OPERATING_UNIT FROM AR_PAYMENT_SCHEDULES APS , OKL_CNSLD_AR_STRMS_B LSM , OKL_CNSLD_AR_LINES_B LLN , OKL_CNSLD_AR_HDRS_B CNR , AR_AGING_BUCKET_LINES AABL , RA_CUSTOMER_TRX RCT , HZ_CUST_ACCOUNTS HZCA , HR_OPERATING_UNITS HU WHERE LSM.RECEIVABLES_INVOICE_ID = RCT.CUSTOMER_TRX_ID AND LSM.LLN_ID = LLN.ID AND LLN.CNR_ID = CNR.ID and (trunc(sysdate) - aps.due_date) >= aabl.days_start and (trunc(sysdate) - aps.due_date) <= aabl.days_to and aps.class = 'INV' and rct.customer_trx_id = aps.customer_trx_id and aps.customer_id = hzca.cust_account_id and rct.interface_header_attribute9 <> 'CURE' and rct.interface_header_context = 'OKL_CONTRACTS' and aps.status = 'OP' and aps.org_id = hu.organization_id

View Text - HTML Formatted

SELECT DISTINCT CNR.ID CONSOLIDATED_INVOICE_ID
, HZCA.PARTY_ID PARTY_ID
, APS.CUSTOMER_ID CUST_ACCOUNT_ID
, APS.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, AABL.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID
, CNR.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER
, CNR.AMOUNT CONSOLIDATED_INVOICE_AMOUNT
, APS.INVOICE_CURRENCY_CODE CONSOLIDATED_INVOICE_AMOUNT_CC
, CNR.DUE_DATE CONSOLIDATED_INVOICE_DUE_DATE
, CNR.DATE_CONSOLIDATED DATE_CONSOLIDATED
, APS.ORG_ID ORG_ID
, HU.NAME OPERATING_UNIT
FROM AR_PAYMENT_SCHEDULES APS
, OKL_CNSLD_AR_STRMS_B LSM
, OKL_CNSLD_AR_LINES_B LLN
, OKL_CNSLD_AR_HDRS_B CNR
, AR_AGING_BUCKET_LINES AABL
, RA_CUSTOMER_TRX RCT
, HZ_CUST_ACCOUNTS HZCA
, HR_OPERATING_UNITS HU
WHERE LSM.RECEIVABLES_INVOICE_ID = RCT.CUSTOMER_TRX_ID
AND LSM.LLN_ID = LLN.ID
AND LLN.CNR_ID = CNR.ID
AND (TRUNC(SYSDATE) - APS.DUE_DATE) >= AABL.DAYS_START
AND (TRUNC(SYSDATE) - APS.DUE_DATE) <= AABL.DAYS_TO
AND APS.CLASS = 'INV'
AND RCT.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
AND APS.CUSTOMER_ID = HZCA.CUST_ACCOUNT_ID
AND RCT.INTERFACE_HEADER_ATTRIBUTE9 <> 'CURE'
AND RCT.INTERFACE_HEADER_CONTEXT = 'OKL_CONTRACTS'
AND APS.STATUS = 'OP'
AND APS.ORG_ID = HU.ORGANIZATION_ID