DBA Data[Home] [Help]

APPS.AR_RECEIPT_LIB_PVT dependencies on AR_OPEN_TRX_V

Line 3658: -- instead of accessing the view ar_open_trx_v. This is because

3654: --called from the BR Remittance program
3655:
3656: -- To handle the case where the apply routine is called from the
3657: -- BR Remittance program, we refer to the underlying tables directly
3658: -- instead of accessing the view ar_open_trx_v. This is because
3659: -- as per the view definition of ar_open_trx_v it will not return the
3660: -- 'reserved'(having reserved_type and reserved_value not null)
3661: -- transactions(Bill).
3662:

Line 3659: -- as per the view definition of ar_open_trx_v it will not return the

3655:
3656: -- To handle the case where the apply routine is called from the
3657: -- BR Remittance program, we refer to the underlying tables directly
3658: -- instead of accessing the view ar_open_trx_v. This is because
3659: -- as per the view definition of ar_open_trx_v it will not return the
3660: -- 'reserved'(having reserved_type and reserved_value not null)
3661: -- transactions(Bill).
3662:
3663: IF arp_global.sysparam.pay_unrelated_invoices_flag = 'Y' THEN

Line 3947: ar_open_trx_v ot

3943: p_rec_charges_charged,
3944: p_rec_charges_remaining,
3945: l_location
3946: FROM
3947: ar_open_trx_v ot
3948: WHERE
3949: ot.customer_trx_id = p_customer_trx_id and
3950: ot.invoice_currency_code =
3951: DECODE(NVL(pg_profile_enable_cc,'N'),

Line 4057: ar_open_trx_v ot

4053: p_rec_charges_charged,
4054: p_rec_charges_remaining,
4055: l_location
4056: FROM
4057: ar_open_trx_v ot
4058: WHERE
4059: ot.customer_trx_id = p_customer_trx_id and
4060: ot.invoice_currency_code =
4061: DECODE(NVL(pg_profile_enable_cc,'N'),