APPS.JA_CN_CR_EXPORT_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 98: AR_CASH_RECEIPT_HISTORY_ALL CRH_REM,

94: FROM
95: HZ_PARTIES PARTY,
96: HZ_CUST_ACCOUNTS CUST,
97: AR_CASH_RECEIPTS_ALL CR,
98: AR_CASH_RECEIPT_HISTORY_ALL CRH_REM,
99: AR_BATCHES_ALL REM_BAT,
100: AR_BATCHES_ALL BAT,
101: AR_BATCHES_ALL BAT_BR,
102: AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED

Line 102: AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED

98: AR_CASH_RECEIPT_HISTORY_ALL CRH_REM,
99: AR_BATCHES_ALL REM_BAT,
100: AR_BATCHES_ALL BAT,
101: AR_BATCHES_ALL BAT_BR,
102: AR_CASH_RECEIPT_HISTORY_ALL CRH_FIRST_POSTED
103: WHERE
104: CR.PAY_FROM_CUSTOMER = CUST.CUST_ACCOUNT_ID (+)
105: AND CUST.PARTY_ID = PARTY.PARTY_ID(+)
106: AND CRH_REM.CASH_RECEIPT_ID (+) = CR.CASH_RECEIPT_ID

Line 110: FROM AR_CASH_RECEIPT_HISTORY_ALL CRH3

106: AND CRH_REM.CASH_RECEIPT_ID (+) = CR.CASH_RECEIPT_ID
107: AND CRH_REM.ORG_ID (+) = CR.ORG_ID
108: AND NOT EXISTS
109: ( SELECT CASH_RECEIPT_HISTORY_ID
110: FROM AR_CASH_RECEIPT_HISTORY_ALL CRH3
111: WHERE CRH3.STATUS = 'REMITTED'
112: AND CRH3.CASH_RECEIPT_ID = CR.CASH_RECEIPT_ID
113: AND CRH3.CASH_RECEIPT_HISTORY_ID < CRH_REM.CASH_RECEIPT_HISTORY_ID)
114: AND CRH_REM.STATUS(+) = 'REMITTED'