VIEW: APPS.IEX_LM_PAYMENTS_V

Source

View Text - Preformatted

SELECT CR.CASH_RECEIPT_ID, CR.RECEIPT_NUMBER, CR.RECEIPT_DATE, CR.STATUS, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('CHECK_STATUS', CR.STATUS), CRH_CURRENT.ACCTD_AMOUNT, CR.AMOUNT, CR.DOC_SEQUENCE_VALUE, CRH_CURRENT.GL_POSTED_DATE, CRH_FIRST_POSTED.GL_DATE, CR.CURRENCY_CODE, REC_METHOD.NAME, CRH_CURRENT.STATUS, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RECEIPT_CREATION_STATUS', CRH_CURRENT.STATUS), CR.PAY_FROM_CUSTOMER, CUST.ACCOUNT_NUMBER, CR.TYPE, PRTY.PARTY_ID, PRTY.PARTY_TYPE, PRTY.PARTY_NAME, PRTY.PERSON_FIRST_NAME, PRTY.PERSON_LAST_NAME FROM HZ_PARTIES PRTY ,HZ_CUST_ACCOUNTS CUST ,AR_CASH_RECEIPTS CR ,HZ_CUST_SITE_USES SITE_USES ,AR_CASH_RECEIPT_HISTORY CRH_CURRENT ,AR_CASH_RECEIPT_HISTORY CRH_FIRST_POSTED ,AR_RECEIPT_METHODS REC_METHOD WHERE CUST.PARTY_ID = PRTY.PARTY_ID(+) AND CR.PAY_FROM_CUSTOMER = CUST.CUST_ACCOUNT_ID (+) AND CR.CUSTOMER_SITE_USE_ID = SITE_USES.SITE_USE_ID (+) and CR.CASH_RECEIPT_ID = CRH_CURRENT.CASH_RECEIPT_ID AND CRH_CURRENT.CURRENT_RECORD_FLAG = 'Y' AND CRH_FIRST_POSTED.CASH_RECEIPT_ID(+) = CR.CASH_RECEIPT_ID AND CRH_FIRST_POSTED.FIRST_POSTED_RECORD_FLAG(+) = 'Y' and CR.RECEIPT_METHOD_ID = REC_METHOD.RECEIPT_METHOD_ID

View Text - HTML Formatted

SELECT CR.CASH_RECEIPT_ID
, CR.RECEIPT_NUMBER
, CR.RECEIPT_DATE
, CR.STATUS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('CHECK_STATUS'
, CR.STATUS)
, CRH_CURRENT.ACCTD_AMOUNT
, CR.AMOUNT
, CR.DOC_SEQUENCE_VALUE
, CRH_CURRENT.GL_POSTED_DATE
, CRH_FIRST_POSTED.GL_DATE
, CR.CURRENCY_CODE
, REC_METHOD.NAME
, CRH_CURRENT.STATUS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('RECEIPT_CREATION_STATUS'
, CRH_CURRENT.STATUS)
, CR.PAY_FROM_CUSTOMER
, CUST.ACCOUNT_NUMBER
, CR.TYPE
, PRTY.PARTY_ID
, PRTY.PARTY_TYPE
, PRTY.PARTY_NAME
, PRTY.PERSON_FIRST_NAME
, PRTY.PERSON_LAST_NAME
FROM HZ_PARTIES PRTY
, HZ_CUST_ACCOUNTS CUST
, AR_CASH_RECEIPTS CR
, HZ_CUST_SITE_USES SITE_USES
, AR_CASH_RECEIPT_HISTORY CRH_CURRENT
, AR_CASH_RECEIPT_HISTORY CRH_FIRST_POSTED
, AR_RECEIPT_METHODS REC_METHOD
WHERE CUST.PARTY_ID = PRTY.PARTY_ID(+)
AND CR.PAY_FROM_CUSTOMER = CUST.CUST_ACCOUNT_ID (+)
AND CR.CUSTOMER_SITE_USE_ID = SITE_USES.SITE_USE_ID (+)
AND CR.CASH_RECEIPT_ID = CRH_CURRENT.CASH_RECEIPT_ID
AND CRH_CURRENT.CURRENT_RECORD_FLAG = 'Y'
AND CRH_FIRST_POSTED.CASH_RECEIPT_ID(+) = CR.CASH_RECEIPT_ID
AND CRH_FIRST_POSTED.FIRST_POSTED_RECORD_FLAG(+) = 'Y'
AND CR.RECEIPT_METHOD_ID = REC_METHOD.RECEIPT_METHOD_ID