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.ARP_CASH_BASIS_JE_REPORT dependencies on AR_CASH_RECEIPTS

Line 8: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,

4: -- RECORD holder for pertinent information about the cash receipt that drives
5: -- the posting of an application
6: TYPE ReceiptType IS RECORD
7: (
8: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
9: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
10: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
11: CustomerNumber hz_cust_accounts.account_number%TYPE,
12: CurrencyCode ar_cash_receipts.currency_code%TYPE,

Line 9: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,

5: -- the posting of an application
6: TYPE ReceiptType IS RECORD
7: (
8: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
9: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
10: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
11: CustomerNumber hz_cust_accounts.account_number%TYPE,
12: CurrencyCode ar_cash_receipts.currency_code%TYPE,
13: ExchangeRate NUMBER

Line 10: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,

6: TYPE ReceiptType IS RECORD
7: (
8: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
9: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
10: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
11: CustomerNumber hz_cust_accounts.account_number%TYPE,
12: CurrencyCode ar_cash_receipts.currency_code%TYPE,
13: ExchangeRate NUMBER
14: );

Line 12: CurrencyCode ar_cash_receipts.currency_code%TYPE,

8: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
9: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
10: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
11: CustomerNumber hz_cust_accounts.account_number%TYPE,
12: CurrencyCode ar_cash_receipts.currency_code%TYPE,
13: ExchangeRate NUMBER
14: );
15: --
16: -- RECORD holder of information about the Trx to which the application

Line 1232: ar_cash_receipts cr,

1228: ra.status Status,
1229: l_cat.meaning CatMeaning,
1230: cr.org_id OrgId
1231: FROM ar_receivable_applications ra,
1232: ar_cash_receipts cr,
1233: hz_cust_accounts cust,
1234: ar_lookups l_cat
1235: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom
1236: AND p_Report.GLDateTo

Line 1483: ar_cash_receipts cr,

1479: ct.org_id OrgID
1480: FROM ar_receivable_applications ra,
1481: ra_cust_trx_types ctt,
1482: ra_customer_trx ct,
1483: ar_cash_receipts cr,
1484: ar_cash_receipt_history crh,
1485: ra_customer_trx ctcm,
1486: ar_lookups l,
1487: ar_lookups l_cat,

Line 1678: ar_cash_receipts cr,

1674: l_cat.meaning CatMeaning,
1675: d.source_type SourceType,
1676: cr.org_id OrgId
1677: FROM ar_cash_receipt_history crh,
1678: ar_cash_receipts cr,
1679: hz_cust_accounts cust,
1680: ar_lookups l_cat,
1681: ar_distributions d
1682: WHERE crh.gl_date BETWEEN p_Report.GlDateFrom

Line 1848: ar_cash_receipts cr,

1844: 'Misc Receipts' category,
1845: l_cat.meaning CatMeaning,
1846: cr.org_id OrgId
1847: FROM ar_misc_cash_distributions mcd,
1848: ar_cash_receipts cr,
1849: ar_lookups l_cat
1850: WHERE mcd.gl_date BETWEEN p_Report.GlDateFrom
1851: AND p_Report.GLDateTo
1852: AND cr.cash_receipt_id = mcd.cash_receipt_id