VIEW: APPS.OKL_BPD_INV_SRCH_V

Source

View Text - Preformatted

SELECT ARV.IXX_ID IXX_ID, NULL CNR_ID, ARV.DUE_DATE DUE_DATE, PY.PARTY_NAME PARTY_NAME, ARV.CURRENCY_CODE CURRENCY_CODE, ARV.TRX_NUMBER CONSOLIDATED_INVOICE_NUMBER, ARV.INVOICE_ID RECEIVABLES_INVOICE_ID, ARV.DATE_CONSOLIDATED DATE_CONSOLIDATED, ARV.RECEIPT_METHOD_ID IRM_ID, ARM.NAME RECEIPT_METHOD_NAME, /*--to_number(ARV.INF_ID) INF_ID,*/ INF.ID INF_ID, NVL(INF.NAME,'NONE') NAME, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,ADDR.ADDRESS1,ADDR.ADDRESS2,ADDR.ADDRESS3, ADDR.ADDRESS4 ,ADDR.CITY,ADDR.COUNTY,ADDR.STATE,ADDR.PROVINCE,ADDR.POSTAL_CODE,NULL,ADDR.COUNTRY,NULL,NULL,NULL ,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) ADDRESS, ARV.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL, ARV.BALANCE BALANCE, ARV.ORG_ID ORG_ID FROM OKL_BPD_AR_INVOICES_V ARV,HZ_CUST_ACCOUNTS CA,HZ_PARTIES PY,OKL_INVOICE_FORMATS_V INF,AR_RECEIPT_METHODS ARM,AR_ADDRESSES_V ADDR WHERE ARV.PAY_SCH_CLASS IN ('INV','CM') AND CA.CUST_ACCOUNT_ID = ARV.IXX_ID AND PY.PARTY_ID = CA.PARTY_ID AND ARV.INF_NAME = INF.NAME(+) AND ARV.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID(+) AND ARV.CUSTOMER_ID = CA.CUST_ACCOUNT_ID AND ARV.BILL_TO_SITE_USE_ID= ADDR.ADDRESS_ID (+)

View Text - HTML Formatted

SELECT ARV.IXX_ID IXX_ID
, NULL CNR_ID
, ARV.DUE_DATE DUE_DATE
, PY.PARTY_NAME PARTY_NAME
, ARV.CURRENCY_CODE CURRENCY_CODE
, ARV.TRX_NUMBER CONSOLIDATED_INVOICE_NUMBER
, ARV.INVOICE_ID RECEIVABLES_INVOICE_ID
, ARV.DATE_CONSOLIDATED DATE_CONSOLIDATED
, ARV.RECEIPT_METHOD_ID IRM_ID
, ARM.NAME RECEIPT_METHOD_NAME
, /*--TO_NUMBER(ARV.INF_ID) INF_ID
, */ INF.ID INF_ID
, NVL(INF.NAME
, 'NONE') NAME
, SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL
, ADDR.ADDRESS1
, ADDR.ADDRESS2
, ADDR.ADDRESS3
, ADDR.ADDRESS4
, ADDR.CITY
, ADDR.COUNTY
, ADDR.STATE
, ADDR.PROVINCE
, ADDR.POSTAL_CODE
, NULL
, ADDR.COUNTRY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
, 'N'
, 80
, 1
, 1)
, 1
, 80) ADDRESS
, ARV.AMOUNT_DUE_ORIGINAL AMOUNT_DUE_ORIGINAL
, ARV.BALANCE BALANCE
, ARV.ORG_ID ORG_ID
FROM OKL_BPD_AR_INVOICES_V ARV
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, OKL_INVOICE_FORMATS_V INF
, AR_RECEIPT_METHODS ARM
, AR_ADDRESSES_V ADDR
WHERE ARV.PAY_SCH_CLASS IN ('INV'
, 'CM')
AND CA.CUST_ACCOUNT_ID = ARV.IXX_ID
AND PY.PARTY_ID = CA.PARTY_ID
AND ARV.INF_NAME = INF.NAME(+)
AND ARV.RECEIPT_METHOD_ID = ARM.RECEIPT_METHOD_ID(+)
AND ARV.CUSTOMER_ID = CA.CUST_ACCOUNT_ID
AND ARV.BILL_TO_SITE_USE_ID= ADDR.ADDRESS_ID (+)