VIEW: APPS.IEX_CASH_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.STATUS RECEIPT_STATUS, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('CHECK_STATUS', ARCR.STATUS) RECEIPT_STATUS_DSP, CRH_CURRENT.ACCTD_AMOUNT FUNCTIONAL_AMOUNT, CRH_CURRENT.AMOUNT NET_AMOUNT, ARCR.AMOUNT AMOUNT, ARCR.DOC_SEQUENCE_VALUE DOCUMENT_NUMBER, CRH_CURRENT.GL_POSTED_DATE POSTED_DATE, CRH_FIRST_POSTED.GL_DATE GL_DATE, ARCR.CURRENCY_CODE CURRENCY_CODE, REC_METHOD.NAME PAYMENT_METHOD_DSP, ARCR.COMMENTS COMMENTS, ARCR.PAY_FROM_CUSTOMER CUSTOMER_ID, ARPT_SQL_FUNC_UTIL.get_lookup_meaning('RECEIPT_CREATION_STATUS', CRH_CURRENT.STATUS) STATE_DSP, CRH_CURRENT.STATUS STATE, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER, SITE_USES.LOCATION LOCATION, ARCR.ORG_ID ORG_ID, ARCR.REVERSAL_COMMENTS REVERSAL_COMMENTS , ARCR.APPLICATION_NOTES APPLICATION_NOTES , ARCR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ARCR.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, SUBSTRB(PARTY.PARTY_NAME,1,50) CUSTOMER_NAME from ar_cash_receipts_all ARCR, HZ_CUST_ACCOUNTS CUST, AR_CASH_RECEIPT_HISTORY_ALL CRH_CURRENT, AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED, AR_RECEIPT_METHODS REC_METHOD, HZ_CUST_SITE_USES_ALL SITE_USES, HZ_PARTIES PARTY WHERE cust.cust_account_id = ARCR.PAY_FROM_CUSTOMER AND CUST.PARTY_ID = PARTY.PARTY_ID AND CRH_CURRENT.CASH_RECEIPT_ID = ARCR.CASH_RECEIPT_ID AND CRH_CURRENT.ORG_ID = ARCR.ORG_ID AND CRH_CURRENT.CURRENT_RECORD_FLAG = NVL('Y',ARCR.RECEIPT_NUMBER) AND ARCR.RECEIPT_METHOD_ID = REC_METHOD.RECEIPT_METHOD_ID AND ARCR.CUSTOMER_SITE_USE_ID = SITE_USES.SITE_USE_ID (+) AND CRH_FIRST_POSTED.CASH_RECEIPT_ID(+) = ARCR.CASH_RECEIPT_ID AND CRH_FIRST_POSTED.ORG_ID = ARCR.ORG_ID AND CRH_FIRST_POSTED.CURRENT_RECORD_FLAG = NVL('Y',ARCR.RECEIPT_NUMBER)

View Text - HTML Formatted

SELECT ARCR.CASH_RECEIPT_ID CASH_RECEIPT_ID
, ARCR.RECEIPT_NUMBER RECEIPT_NUMBER
, ARCR.RECEIPT_DATE RECEIPT_DATE
, ARCR.STATUS RECEIPT_STATUS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('CHECK_STATUS'
, ARCR.STATUS) RECEIPT_STATUS_DSP
, CRH_CURRENT.ACCTD_AMOUNT FUNCTIONAL_AMOUNT
, CRH_CURRENT.AMOUNT NET_AMOUNT
, ARCR.AMOUNT AMOUNT
, ARCR.DOC_SEQUENCE_VALUE DOCUMENT_NUMBER
, CRH_CURRENT.GL_POSTED_DATE POSTED_DATE
, CRH_FIRST_POSTED.GL_DATE GL_DATE
, ARCR.CURRENCY_CODE CURRENCY_CODE
, REC_METHOD.NAME PAYMENT_METHOD_DSP
, ARCR.COMMENTS COMMENTS
, ARCR.PAY_FROM_CUSTOMER CUSTOMER_ID
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RECEIPT_CREATION_STATUS'
, CRH_CURRENT.STATUS) STATE_DSP
, CRH_CURRENT.STATUS STATE
, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER
, SITE_USES.LOCATION LOCATION
, ARCR.ORG_ID ORG_ID
, ARCR.REVERSAL_COMMENTS REVERSAL_COMMENTS
, ARCR.APPLICATION_NOTES APPLICATION_NOTES
, ARCR.LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ARCR.CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
FROM AR_CASH_RECEIPTS_ALL ARCR
, HZ_CUST_ACCOUNTS CUST
, AR_CASH_RECEIPT_HISTORY_ALL CRH_CURRENT
, AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED
, AR_RECEIPT_METHODS REC_METHOD
, HZ_CUST_SITE_USES_ALL SITE_USES
, HZ_PARTIES PARTY
WHERE CUST.CUST_ACCOUNT_ID = ARCR.PAY_FROM_CUSTOMER
AND CUST.PARTY_ID = PARTY.PARTY_ID
AND CRH_CURRENT.CASH_RECEIPT_ID = ARCR.CASH_RECEIPT_ID
AND CRH_CURRENT.ORG_ID = ARCR.ORG_ID
AND CRH_CURRENT.CURRENT_RECORD_FLAG = NVL('Y'
, ARCR.RECEIPT_NUMBER)
AND ARCR.RECEIPT_METHOD_ID = REC_METHOD.RECEIPT_METHOD_ID
AND ARCR.CUSTOMER_SITE_USE_ID = SITE_USES.SITE_USE_ID (+)
AND CRH_FIRST_POSTED.CASH_RECEIPT_ID(+) = ARCR.CASH_RECEIPT_ID
AND CRH_FIRST_POSTED.ORG_ID = ARCR.ORG_ID
AND CRH_FIRST_POSTED.CURRENT_RECORD_FLAG = NVL('Y'
, ARCR.RECEIPT_NUMBER)