DBA Data[Home] [Help]

APPS.IGIRCBJP dependencies on AR_CASH_RECEIPTS

Line 18: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,

14: -- RECORD holder for pertinent information about the cash receipt that drives
15: -- the posting of an application
16: TYPE ReceiptType IS RECORD
17: (
18: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
19: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
20: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
21: CustomerNumber hz_cust_accounts.account_number%TYPE, -- Bug 3902175
22: CurrencyCode ar_cash_receipts.currency_code%TYPE,

Line 19: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,

15: -- the posting of an application
16: TYPE ReceiptType IS RECORD
17: (
18: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
19: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
20: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
21: CustomerNumber hz_cust_accounts.account_number%TYPE, -- Bug 3902175
22: CurrencyCode ar_cash_receipts.currency_code%TYPE,
23: ExchangeRate NUMBER

Line 20: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,

16: TYPE ReceiptType IS RECORD
17: (
18: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
19: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
20: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
21: CustomerNumber hz_cust_accounts.account_number%TYPE, -- Bug 3902175
22: CurrencyCode ar_cash_receipts.currency_code%TYPE,
23: ExchangeRate NUMBER
24: );

Line 22: CurrencyCode ar_cash_receipts.currency_code%TYPE,

18: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
19: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
20: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
21: CustomerNumber hz_cust_accounts.account_number%TYPE, -- Bug 3902175
22: CurrencyCode ar_cash_receipts.currency_code%TYPE,
23: ExchangeRate NUMBER
24: );
25: --
26: -- RECORD holder of information about the Trx to which the application

Line 1185: ar_cash_receipts cr,

1181: ra.status Status,
1182: l_cat.meaning CatMeaning
1183: FROM ar_receivable_applications ra,
1184: igi_ar_rec_applications igira,
1185: ar_cash_receipts cr,
1186: hz_parties, -- Bug 3902175
1187: hz_cust_accounts, -- Bug 3902175
1188: ar_lookups l_cat,
1189: xla_ae_headers xah

Line 1476: ar_cash_receipts cr,

1472: FROM ar_receivable_applications ra,
1473: igi_ar_rec_applications igira,
1474: ra_cust_trx_types ctt,
1475: ra_customer_trx ct,
1476: ar_cash_receipts cr,
1477: ar_cash_receipt_history crh,
1478: ra_customer_trx ctcm,
1479: ar_lookups l,
1480: ar_lookups l_cat,

Line 1707: ar_cash_receipts cr,

1703: l_cat.meaning CatMeaning,
1704: d.source_type SourceType
1705: FROM ar_cash_receipt_history crh,
1706: igi_ar_cash_receipt_hist igicrh,
1707: ar_cash_receipts cr,
1708: (Select hz_cust_accounts.account_number customer_number,hz_cust_accounts.cust_account_id customer_id
1709: from hz_parties,hz_cust_accounts where hz_parties.party_id = hz_cust_accounts.party_id) cust, -- bug 3902175
1710: ar_lookups l_cat,
1711: ar_distributions d,

Line 1928: ar_cash_receipts cr,

1924: 'Misc Receipts' category,
1925: l_cat.meaning CatMeaning
1926: FROM ar_misc_cash_distributions mcd,
1927: igi_ar_misc_cash_dists igimcd,
1928: ar_cash_receipts cr,
1929: ar_lookups l_cat,
1930: xla_ae_headers xah
1931: WHERE mcd.gl_date BETWEEN p_Report.GlDateFrom AND p_Report.GLDateTo
1932: AND cr.cash_receipt_id = mcd.cash_receipt_id