VIEW: APPS.IEX_RECEIPTS_V

Source

View Text - Preformatted

SELECT ARCR.CASH_RECEIPT_ID CASH_RECEIPT_ID, ARCR.RECEIPT_NUMBER RECEIPT_NUMBER, ARCR.RECEIPT_DATE RECEIPT_DATE, ARCR.RECEIPT_STATUS RECEIPT_STATUS, ARCR.RECEIPT_STATUS_DSP RECEIPT_STATUS_DSP, ARCR.FUNCTIONAL_AMOUNT FUNCTIONAL_AMOUNT, ARCR.AMOUNT AMOUNT, ARCR.DOCUMENT_NUMBER DOCUMENT_NUMBER, ARCR.POSTED_DATE POSTED_DATE, ARCR.GL_DATE GL_DATE, ARCR.CURRENCY_CODE CURRENCY_CODE, ARCR.PAYMENT_METHOD_DSP PAYMENT_METHOD_DSP, ARCR.STATE STATE, ARCR.COMMENTS COMMENTS, ARCR.CUSTOMER_ID CUSTOMER_ID, IEPRX.PAYMENT_ID PAYMENT_ID, IEPAY.PAYEE_ID PAYEE_ID, IEPAY.TANGIBLE_ID TANGIBLE_ID, IEPAY.PAYMENT_METHOD PAYMENT_METHOD, IEPAY.PAYMENT_METHOD_ID PAYMENT_METHOD_ID, IEPAY.RESOURCE_ID RESOURCE_ID, DECODE(IEPAY.RESOURCE_ID,NULL,'A/RRR',REX.SOURCE_NAME) RESOURCE_NAME, ARCR.STATE_DSP STATE_DSP, ARCR.CUSTOMER_NUMBER CUSTOMER_NUMBER, ARCR.LOCATION LOCATION, GLL.CURRENCY_CODE FUNCTIONAL_CURRENCY, ARCR.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, SUBSTR(LOC.ADDRESS1,1,25) ||' ' || SUBSTR(LOC.ADDRESS2,1,25) ||' ' || SUBSTR(LOC.ADDRESS3,1,25) ||' ' || SUBSTR(LOC.ADDRESS4,1,25) ||' ' || LOC.CITY|| ',' || ' ' || NVL(LOC.STATE, LOC.PROVINCE) ||' ' || T.TERRITORY_SHORT_NAME ADDRESS , PARTY_SITE.PARTY_SITE_NUMBER PARTY_SITE_NUMBER , ARCR.CUSTOMER_NAME CUSTOMER_NAME, ARCR.ORG_ID ORG_ID, MO_GLOBAL.GET_OU_NAME(ARCR.ORG_ID) OPERATING_UNIT , ARCR.REVERSAL_COMMENTS RECEIVABLES_REVERSAL_COMMENTS , ARCR.APPLICATION_NOTES RECEIVABLES_APPL_NOTES , ARCR.COMMENTS RECEIVABLES_COMMENTS, ARCR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID, XEP.NAME LEGAL_ENTITY_NAME FROM IEX_PAY_RECEIPT_XREF IEPRX, IEX_PAYMENTS IEPAY, IEX_CASH_RECEIPTS_V ARCR, JTF_RS_RESOURCE_EXTNS REX, AR_SYSTEM_PARAMETERS SP, GL_LEDGERS_PUBLIC_V GLL, HZ_CUST_ACCT_SITES ACCT_SITE , HZ_PARTY_SITES PARTY_SITE , HZ_LOCATIONS LOC , HZ_CUST_SITE_USES SITE_USES , FND_TERRITORIES_VL T, XLE_ENTITY_PROFILES XEP WHERE ARCR.CASH_RECEIPT_ID = IEPRX.CASH_RECEIPT_ID(+) AND IEPRX.PAYMENT_ID = IEPAY.PAYMENT_ID(+) AND IEPAY.RESOURCE_ID = REX.RESOURCE_ID(+) AND SP.ORG_ID=ARCR.ORG_ID AND GLL.LEDGER_ID = SP.SET_OF_BOOKS_ID AND SITE_USES.SITE_USE_ID(+) = ARCR.CUSTOMER_SITE_USE_ID AND SITE_USES.SITE_USE_CODE(+) = 'BILL_TO' AND SITE_USES.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+) AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+) AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID(+) AND LOC.COUNTRY = T.TERRITORY_CODE(+) AND ARCR.LEGAL_ENTITY_ID = XEP.LEGAL_ENTITY_ID(+)

View Text - HTML Formatted

SELECT ARCR.CASH_RECEIPT_ID CASH_RECEIPT_ID
, ARCR.RECEIPT_NUMBER RECEIPT_NUMBER
, ARCR.RECEIPT_DATE RECEIPT_DATE
, ARCR.RECEIPT_STATUS RECEIPT_STATUS
, ARCR.RECEIPT_STATUS_DSP RECEIPT_STATUS_DSP
, ARCR.FUNCTIONAL_AMOUNT FUNCTIONAL_AMOUNT
, ARCR.AMOUNT AMOUNT
, ARCR.DOCUMENT_NUMBER DOCUMENT_NUMBER
, ARCR.POSTED_DATE POSTED_DATE
, ARCR.GL_DATE GL_DATE
, ARCR.CURRENCY_CODE CURRENCY_CODE
, ARCR.PAYMENT_METHOD_DSP PAYMENT_METHOD_DSP
, ARCR.STATE STATE
, ARCR.COMMENTS COMMENTS
, ARCR.CUSTOMER_ID CUSTOMER_ID
, IEPRX.PAYMENT_ID PAYMENT_ID
, IEPAY.PAYEE_ID PAYEE_ID
, IEPAY.TANGIBLE_ID TANGIBLE_ID
, IEPAY.PAYMENT_METHOD PAYMENT_METHOD
, IEPAY.PAYMENT_METHOD_ID PAYMENT_METHOD_ID
, IEPAY.RESOURCE_ID RESOURCE_ID
, DECODE(IEPAY.RESOURCE_ID
, NULL
, 'A/RRR'
, REX.SOURCE_NAME) RESOURCE_NAME
, ARCR.STATE_DSP STATE_DSP
, ARCR.CUSTOMER_NUMBER CUSTOMER_NUMBER
, ARCR.LOCATION LOCATION
, GLL.CURRENCY_CODE FUNCTIONAL_CURRENCY
, ARCR.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, SUBSTR(LOC.ADDRESS1
, 1
, 25) ||' ' || SUBSTR(LOC.ADDRESS2
, 1
, 25) ||' ' || SUBSTR(LOC.ADDRESS3
, 1
, 25) ||' ' || SUBSTR(LOC.ADDRESS4
, 1
, 25) ||' ' || LOC.CITY|| '
, ' || ' ' || NVL(LOC.STATE
, LOC.PROVINCE) ||' ' || T.TERRITORY_SHORT_NAME ADDRESS
, PARTY_SITE.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
, ARCR.CUSTOMER_NAME CUSTOMER_NAME
, ARCR.ORG_ID ORG_ID
, MO_GLOBAL.GET_OU_NAME(ARCR.ORG_ID) OPERATING_UNIT
, ARCR.REVERSAL_COMMENTS RECEIVABLES_REVERSAL_COMMENTS
, ARCR.APPLICATION_NOTES RECEIVABLES_APPL_NOTES
, ARCR.COMMENTS RECEIVABLES_COMMENTS
, ARCR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, XEP.NAME LEGAL_ENTITY_NAME
FROM IEX_PAY_RECEIPT_XREF IEPRX
, IEX_PAYMENTS IEPAY
, IEX_CASH_RECEIPTS_V ARCR
, JTF_RS_RESOURCE_EXTNS REX
, AR_SYSTEM_PARAMETERS SP
, GL_LEDGERS_PUBLIC_V GLL
, HZ_CUST_ACCT_SITES ACCT_SITE
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CUST_SITE_USES SITE_USES
, FND_TERRITORIES_VL T
, XLE_ENTITY_PROFILES XEP
WHERE ARCR.CASH_RECEIPT_ID = IEPRX.CASH_RECEIPT_ID(+)
AND IEPRX.PAYMENT_ID = IEPAY.PAYMENT_ID(+)
AND IEPAY.RESOURCE_ID = REX.RESOURCE_ID(+)
AND SP.ORG_ID=ARCR.ORG_ID
AND GLL.LEDGER_ID = SP.SET_OF_BOOKS_ID
AND SITE_USES.SITE_USE_ID(+) = ARCR.CUSTOMER_SITE_USE_ID
AND SITE_USES.SITE_USE_CODE(+) = 'BILL_TO'
AND SITE_USES.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID(+)
AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID(+)
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID(+)
AND LOC.COUNTRY = T.TERRITORY_CODE(+)
AND ARCR.LEGAL_ENTITY_ID = XEP.LEGAL_ENTITY_ID(+)