VIEW: APPS.IEX_CNSLD_INV_V

Source

View Text - Preformatted

SELECT HD.ID CONSOLIDATED_INVOICE_ID , HD.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER , HD.DATE_CONSOLIDATED CONSOLIDATED_DATE , HD.IXX_ID CUSTOMER_ID , PY.PARTY_NAME CUSTOMER_NAME , CA.ACCOUNT_NUMBER CUSTOMER_NUMBER , HD.CURRENCY_CODE CURRENCY_CODE, PS.CUSTOMER_SITE_USE_ID , SU.LOCATION , SU.PARTY_SITE_NUMBER , SU.ADDRESS, SUM (PS.AMOUNT_DUE_REMAINING) AMOUNT, HD.DUE_DATE DUE_DATE, PS.ORG_ID ORG_ID, MO_GLOBAL.GET_OU_NAME(PS.ORG_ID) OPERATING_UNIT FROM AR_PAYMENT_SCHEDULES PS, OKL_STRM_TYPE_B SM, OKL_CNSLD_AR_HDRS_B HD, OKL_CNSLD_AR_LINES_B LN, OKL_CNSLD_AR_STRMS_B ST, HZ_CUST_ACCOUNTS CA, HZ_PARTIES PY, IEX_CUST_SITE_USES_V SU WHERE LN.CNR_ID = HD.ID AND ST.LLN_ID = LN.ID AND PS.CUSTOMER_TRX_ID = ST.RECEIVABLES_INVOICE_ID AND CA.CUST_ACCOUNT_ID = HD.IXX_ID AND PY.PARTY_ID = CA.PARTY_ID AND SM.ID = ST.STY_ID AND SM.STREAM_TYPE_PURPOSE <> 'CURE' AND PS.CUSTOMER_SITE_USE_ID = SU.CUSTOMER_SITE_USE_ID GROUP BY HD.ID , HD.CONSOLIDATED_INVOICE_NUMBER, HD.DATE_CONSOLIDATED, HD.IXX_ID , PY.PARTY_NAME , PS.CUSTOMER_SITE_USE_ID, HD.CURRENCY_CODE , CA.ACCOUNT_NUMBER, HD.DUE_DATE, SU.LOCATION, SU.PARTY_SITE_NUMBER, SU.ADDRESS, PS.ORG_ID

View Text - HTML Formatted

SELECT HD.ID CONSOLIDATED_INVOICE_ID
, HD.CONSOLIDATED_INVOICE_NUMBER CONSOLIDATED_INVOICE_NUMBER
, HD.DATE_CONSOLIDATED CONSOLIDATED_DATE
, HD.IXX_ID CUSTOMER_ID
, PY.PARTY_NAME CUSTOMER_NAME
, CA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HD.CURRENCY_CODE CURRENCY_CODE
, PS.CUSTOMER_SITE_USE_ID
, SU.LOCATION
, SU.PARTY_SITE_NUMBER
, SU.ADDRESS
, SUM (PS.AMOUNT_DUE_REMAINING) AMOUNT
, HD.DUE_DATE DUE_DATE
, PS.ORG_ID ORG_ID
, MO_GLOBAL.GET_OU_NAME(PS.ORG_ID) OPERATING_UNIT
FROM AR_PAYMENT_SCHEDULES PS
, OKL_STRM_TYPE_B SM
, OKL_CNSLD_AR_HDRS_B HD
, OKL_CNSLD_AR_LINES_B LN
, OKL_CNSLD_AR_STRMS_B ST
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES PY
, IEX_CUST_SITE_USES_V SU
WHERE LN.CNR_ID = HD.ID
AND ST.LLN_ID = LN.ID
AND PS.CUSTOMER_TRX_ID = ST.RECEIVABLES_INVOICE_ID
AND CA.CUST_ACCOUNT_ID = HD.IXX_ID
AND PY.PARTY_ID = CA.PARTY_ID
AND SM.ID = ST.STY_ID
AND SM.STREAM_TYPE_PURPOSE <> 'CURE'
AND PS.CUSTOMER_SITE_USE_ID = SU.CUSTOMER_SITE_USE_ID GROUP BY HD.ID
, HD.CONSOLIDATED_INVOICE_NUMBER
, HD.DATE_CONSOLIDATED
, HD.IXX_ID
, PY.PARTY_NAME
, PS.CUSTOMER_SITE_USE_ID
, HD.CURRENCY_CODE
, CA.ACCOUNT_NUMBER
, HD.DUE_DATE
, SU.LOCATION
, SU.PARTY_SITE_NUMBER
, SU.ADDRESS
, PS.ORG_ID