DBA Data[Home] [Help]

APPS.ARP_CASH_BASIS_ACCOUNTING 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: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
11: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
12: PayFromCustomer ar_cash_receipts.pay_from_customer%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: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
11: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
12: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
13: CurrencyCode ar_cash_receipts.currency_code%TYPE,

Line 10: DocSequenceId ar_cash_receipts.doc_sequence_id%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: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
11: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
12: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
13: CurrencyCode ar_cash_receipts.currency_code%TYPE,
14: ExchangeRate NUMBER

Line 11: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,

7: (
8: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
9: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
10: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
11: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
12: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
13: CurrencyCode ar_cash_receipts.currency_code%TYPE,
14: ExchangeRate NUMBER
15: );

Line 12: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,

8: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
9: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
10: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
11: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
12: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
13: CurrencyCode ar_cash_receipts.currency_code%TYPE,
14: ExchangeRate NUMBER
15: );
16: --

Line 13: CurrencyCode ar_cash_receipts.currency_code%TYPE,

9: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
10: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
11: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
12: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
13: CurrencyCode ar_cash_receipts.currency_code%TYPE,
14: ExchangeRate NUMBER
15: );
16: --
17: -- RECORD holder of information about the Trx to which the application

Line 1255: ar_cash_receipts cr

1251: ra.acctd_amount_applied_from AcctdAmount,
1252: ra.code_combination_id CodeCombinationId,
1253: ra.status Status
1254: FROM ar_receivable_applications ra,
1255: ar_cash_receipts cr
1256: WHERE ra.posting_control_id = p_Post.UnpostedPostingControlId
1257: AND ra.gl_date BETWEEN p_Post.GlDateFrom
1258: AND p_Post.GlDateTo
1259: AND nvl(ra.postable,'Y') = 'Y'

Line 1291: ar_cash_receipts cr

1287: ra.code_combination_id CodeCombinationId,
1288: ra_mrc.status Status
1289: FROM ar_receivable_applications ra,
1290: ar_mc_receivable_apps ra_mrc,
1291: ar_cash_receipts cr
1292: WHERE ra_mrc.posting_control_id = p_Post.UnpostedPostingControlId
1293: AND ra.gl_date BETWEEN p_Post.GlDateFrom
1294: AND p_Post.GlDateTo
1295: AND nvl(ra.postable,'Y') = 'Y'

Line 1711: ar_cash_receipts cr,

1707: ct.org_id OrgId
1708: FROM ar_receivable_applications ra,
1709: ra_cust_trx_types ctt,
1710: ra_customer_trx ct,
1711: ar_cash_receipts cr,
1712: ar_cash_receipt_history crh,
1713: ra_customer_trx ctcm,
1714: ar_lookups l
1715: WHERE ra.posting_control_id = p_Post.UnpostedPostingControlId

Line 1826: -- ar_cash_receipts cr,

1822: -- ) ChargesApplied
1823: -- FROM ar_receivable_apps_mrc_v ra,
1824: -- ra_cust_trx_types ctt,
1825: -- ra_customer_trx ct,
1826: -- ar_cash_receipts cr,
1827: -- ar_cash_receipt_hist_mrc_v crh,
1828: -- ra_customer_trx_mrc_v ctcm,
1829: -- ar_lookups l
1830: -- WHERE ra.posting_control_id = p_Post.UnpostedPostingControlId

Line 2049: ar_cash_receipts cr,

2045: cr.doc_sequence_value DocSequenceValue,
2046: cr.ussgl_transaction_code UssglTransactionCode,
2047: d.source_type SourceType
2048: FROM ar_cash_receipt_history crh,
2049: ar_cash_receipts cr,
2050: ar_distributions d
2051: WHERE crh.gl_date BETWEEN p_Post.GlDateFrom
2052: AND p_Post.GlDateTo
2053: AND crh.posting_control_id = p_Post.UnpostedPostingControlId

Line 2090: -- ar_cash_receipts cr,

2086: -- cr.ussgl_transaction_code UssglTransactionCode,
2087: -- d.source_type SourceType
2088: -- FROM ar_mc_cash_receipt_hist crh_mc,
2089: -- ar_cash_receipt_history crh,
2090: -- ar_cash_receipts cr,
2091: -- ar_distributions_mrc_v d
2092: -- WHERE crh.gl_date BETWEEN p_Post.GlDateFrom
2093: -- AND p_Post.GlDateTo
2094: -- AND crh_mc.posting_control_id = p_Post.UnpostedPostingControlId

Line 2259: ar_cash_receipts cr

2255: cr.doc_sequence_id doc_sequence_id,
2256: cr.doc_sequence_value doc_sequence_value,
2257: mcd.ussgl_transaction_code ussgl_transaction_code
2258: FROM ar_misc_cash_distributions mcd,
2259: ar_cash_receipts cr
2260: WHERE mcd.posting_control_id = p_Post.UnpostedPostingControlId
2261: AND mcd.gl_date BETWEEN p_Post.GlDateFrom
2262: AND p_Post.GlDateTo
2263: AND cr.cash_receipt_id = mcd.cash_receipt_id

Line 2284: ar_cash_receipts cr

2280: cr.doc_sequence_value doc_sequence_value,
2281: mcd.ussgl_transaction_code ussgl_transaction_code
2282: FROM ar_misc_cash_distributions mcd,
2283: ar_mc_misc_cash_dists mcd_mrc,
2284: ar_cash_receipts cr
2285: WHERE mcd.posting_control_id = p_Post.UnpostedPostingControlId
2286: AND mcd.gl_date BETWEEN p_Post.GlDateFrom
2287: AND p_Post.GlDateTo
2288: AND cr.cash_receipt_id = mcd.cash_receipt_id