eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_TRX_SUMMARY_PKG dependencies on AR_CASH_RECEIPTS_ALL

Line 273: from ar_cash_receipts_all cr

269: cr.org_id org_id,
270: to_number(substr(max(to_char(cr.receipt_date, 'YYYYMMDD') ||
271: ltrim(to_char(cr.cash_receipt_id,
272: '0999999999999999999999'))),9)) last_cash_receipt_id
273: from ar_cash_receipts_all cr
274: where NVL(cr.confirmed_flag, 'Y') = 'Y'
275: and cr.reversal_date is null
276: and cr.type = 'CASH'
277: and cr.pay_from_customer IS NOT NULL

Line 280: AR_CASH_RECEIPTS_ALL B

276: and cr.type = 'CASH'
277: and cr.pay_from_customer IS NOT NULL
278: group by pay_from_customer, customer_site_use_id,
279: currency_code, org_id) a1,
280: AR_CASH_RECEIPTS_ALL B
281: WHERE a1.LAST_CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
282: GROUP BY A1.CUSTOMER_ID,
283: A1.CUSTOMER_SITE_USE_ID,
284: A1.CURRENCY,

Line 331: FROM AR_CASH_RECEIPTS_ALL CR,

327: INTO l_at_risk_exists
328: FROM DUAL
329: WHERE EXISTS (
330: SELECT 'at risk receipt'
331: FROM AR_CASH_RECEIPTS_ALL CR,
332: AR_CASH_RECEIPT_HISTORY_ALL CRH
333: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
334: AND CR.REVERSAL_DATE IS NULL
335: AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID

Line 360: FROM AR_CASH_RECEIPTS_ALL CR,

356: CR.CURRENCY_CODE CURRENCY,
357: CR.ORG_ID ORG_ID,
358: SUM(DECODE(RAP.APPLIED_PAYMENT_SCHEDULE_ID,-2,NULL,
359: CRH.AMOUNT)) RECEIPTS_AT_RISK_VALUE
360: FROM AR_CASH_RECEIPTS_ALL CR,
361: AR_CASH_RECEIPT_HISTORY_ALL CRH,
362: AR_RECEIVABLE_APPLICATIONS_ALL RAP
363: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
364: AND CR.REVERSAL_DATE IS NULL

Line 662: from ar_cash_receipts_all cr,

658: 0 unedisc_count,
659: 0 app_amt_days_late,
660: 0 adj_amount,
661: 0 adj_count
662: from ar_cash_receipts_all cr,
663: ar_cash_receipt_history_all crh
664: where cr.cash_receipt_id = crh.cash_receipt_id
665: and crh.current_record_flag = 'Y'
666: and crh.status = 'REVERSED'

Line 1553: from ar_cash_receipts_all cr

1549: cr.org_id,
1550: to_number(substr(max(
1551: to_char(cr.receipt_date, 'YYYYMMDD') ||
1552: ltrim(to_char(cr.cash_receipt_id, '0999999999999999999999'))),9)) last_cash_receipt_id
1553: from ar_cash_receipts_all cr
1554: where NVL(cr.confirmed_flag, 'Y') = 'Y'
1555: and cr.reversal_date is null
1556: and cr.pay_from_customer = p_cust_id(i)
1557: and cr.type = 'CASH'

Line 1559: AR_CASH_RECEIPTS_ALL B

1555: and cr.reversal_date is null
1556: and cr.pay_from_customer = p_cust_id(i)
1557: and cr.type = 'CASH'
1558: group by pay_from_customer, customer_site_use_id, currency_code, org_id) a1,
1559: AR_CASH_RECEIPTS_ALL B
1560: WHERE a1.LAST_CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
1561: UNION ALL
1562: SELECT /*+ LEADING(cr) INDEX(cr,AR_CASH_RECEIPTS_N2) */
1563: CR.PAY_FROM_CUSTOMER CUSTOMER_ID,

Line 1592: FROM AR_CASH_RECEIPTS_ALL CR,

1588: 0 LAST_RECEIPT_AMOUNT,
1589: TO_DATE(NULL) LAST_RECEIPT_DATE,
1590: NULL LAST_RECEIPT_NUMBER,
1591: 0 PENDING_ADJ_AMT
1592: FROM AR_CASH_RECEIPTS_ALL CR,
1593: AR_CASH_RECEIPT_HISTORY_ALL CRH,
1594: AR_RECEIVABLE_APPLICATIONS_ALL RAP
1595: WHERE NVL(CR.CONFIRMED_FLAG, 'Y') = 'Y'
1596: AND CR.REVERSAL_DATE IS NULL

Line 1875: from ar_cash_receipts_all cr,

1871: 0 unedisc_count,
1872: 0 app_amt_days_late,
1873: 0 adj_amount,
1874: 0 adj_count
1875: from ar_cash_receipts_all cr,
1876: ar_cash_receipt_history_all crh
1877: where cr.cash_receipt_id = crh.cash_receipt_id
1878: and crh.current_record_flag = 'Y'
1879: and crh.status = 'REVERSED'