DBA Data[Home] [Help]

APPS.ARP_CASH_BASIS_JE_REPORT dependencies on HZ_CUST_ACCOUNTS

Line 11: CustomerNumber hz_cust_accounts.account_number%TYPE,

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: );
15: --

Line 1233: hz_cust_accounts cust,

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
1237: AND nvl(ra.postable,'Y') = 'Y'

Line 1488: hz_cust_accounts cust

1484: ar_cash_receipt_history crh,
1485: ra_customer_trx ctcm,
1486: ar_lookups l,
1487: ar_lookups l_cat,
1488: hz_cust_accounts cust
1489: WHERE ra.gl_date BETWEEN p_Report.GlDateFrom
1490: AND p_Report.GLDateTo
1491: AND nvl(ra.postable,'Y') = 'Y'
1492: AND nvl(ra.confirmed_flag,'Y') = 'Y'

Line 1679: hz_cust_accounts cust,

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
1683: AND p_Report.GLDateTo