DBA Data[Home] [Help]

APPS.IGIRCBAP dependencies on AR_CASH_RECEIPTS

Line 20: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,

16: -- RECORD holder for pertinent information about the cash receipt that drives
17: -- the posting of an application
18: TYPE ReceiptType IS RECORD
19: (
20: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
21: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
22: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
23: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
24: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,

Line 21: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,

17: -- the posting of an application
18: TYPE ReceiptType IS RECORD
19: (
20: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
21: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
22: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
23: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
24: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
25: CurrencyCode ar_cash_receipts.currency_code%TYPE,

Line 22: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,

18: TYPE ReceiptType IS RECORD
19: (
20: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
21: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
22: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
23: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
24: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
25: CurrencyCode ar_cash_receipts.currency_code%TYPE,
26: ExchangeRate NUMBER

Line 23: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,

19: (
20: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
21: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
22: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
23: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
24: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
25: CurrencyCode ar_cash_receipts.currency_code%TYPE,
26: ExchangeRate NUMBER
27: );

Line 24: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,

20: CashReceiptId ar_cash_receipts.cash_receipt_id%TYPE,
21: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
22: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
23: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
24: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
25: CurrencyCode ar_cash_receipts.currency_code%TYPE,
26: ExchangeRate NUMBER
27: );
28: --

Line 25: CurrencyCode ar_cash_receipts.currency_code%TYPE,

21: ReceiptNumber ar_cash_receipts.receipt_number%TYPE,
22: DocSequenceId ar_cash_receipts.doc_sequence_id%TYPE,
23: DocSequenceValue ar_cash_receipts.doc_sequence_value%TYPE,
24: PayFromCustomer ar_cash_receipts.pay_from_customer%TYPE,
25: CurrencyCode ar_cash_receipts.currency_code%TYPE,
26: ExchangeRate NUMBER
27: );
28: --
29: -- RECORD holder of information about the Trx to which the application

Line 1127: ar_cash_receipts cr

1123: ra.code_combination_id CodeCombinationId,
1124: ra.status Status
1125: FROM ar_receivable_applications ra,
1126: igi_ar_rec_applications igi_ra,
1127: ar_cash_receipts cr
1128: WHERE ra.receivable_application_id = igi_ra.receivable_application_id
1129: AND igi_ra.arc_posting_control_id = p_Post.UnpostedPostingControlId
1130: AND trunc(ra.gl_date) >= p_Post.GlDateFrom
1131: AND trunc(ra.gl_date) <= p_Post.GlDateTo

Line 1391: ar_cash_receipts cr,

1387: FROM ar_receivable_applications ra,
1388: igi_ar_rec_applications igira,
1389: ra_cust_trx_types ctt,
1390: ra_customer_trx ct,
1391: ar_cash_receipts cr,
1392: ar_cash_receipt_history crh,
1393: ra_customer_trx ctcm,
1394: ar_lookups l
1395: WHERE igira.arc_posting_control_id = p_Post.UnpostedPostingControlId

Line 1576: ar_cash_receipts cr,

1572: cr.ussgl_transaction_code UssglTransactionCode,
1573: d.source_type SourceType
1574: FROM ar_cash_receipt_history crh,
1575: igi_ar_cash_receipt_hist igicrh,
1576: ar_cash_receipts cr,
1577: ar_distributions d
1578: WHERE trunc(crh.gl_date) >= p_Post.GlDateFrom
1579: AND trunc(crh.gl_date) <= p_Post.GlDateTo
1580: AND igicrh.arc_posting_control_id = p_Post.UnpostedPostingControlId

Line 1755: ar_cash_receipts cr

1751: cr.doc_sequence_value doc_sequence_value,
1752: mcd.ussgl_transaction_code ussgl_transaction_code
1753: FROM ar_misc_cash_distributions mcd,
1754: igi_ar_misc_cash_dists igimcd,
1755: ar_cash_receipts cr
1756: WHERE igimcd.arc_posting_control_id = p_Post.UnpostedPostingControlId
1757: AND trunc(mcd.gl_date) >= p_Post.GlDateFrom
1758: AND trunc(mcd.gl_date) <= p_Post.GlDateTo
1759: AND cr.cash_receipt_id = mcd.cash_receipt_id