DBA Data[Home] [Help]

APPS.AR_AUTOREC_API dependencies on IBY_TRXN_EXTENSIONS_V

Line 4389: iby_trxn_extensions_v trxn_ext

4385: SELECT r.customer_trx_id
4386: FROM ar_cash_receipts cr,
4387: ar_receipts_gt r,
4388: ar_cash_receipt_history crh,
4389: iby_trxn_extensions_v trxn_ext
4390: WHERE cr.request_id = l_request_id
4391: AND r.cash_receipt_id = cr.cash_receipt_id
4392: AND crh.cash_receipt_id = cr.cash_receipt_id
4393: AND crh.status = 'CONFIRMED'

Line 4439: iby_trxn_extensions_v trxn_ext

4435: l_program_id,
4436: sysdate
4437: FROM ar_cash_receipts cr,
4438: ar_cash_receipt_history crh,
4439: iby_trxn_extensions_v trxn_ext
4440: WHERE cr.request_id = l_request_id
4441: AND crh.cash_receipt_id = cr.cash_receipt_id
4442: AND crh.status = 'CONFIRMED'
4443: AND crh.current_record_flag = 'Y'

Line 4498: iby_trxn_extensions_v trxn_ext

4494: SELECT r.customer_trx_id
4495: FROM ar_cash_receipts cr,
4496: ar_receipts_gt r,
4497: ar_cash_receipt_history crh,
4498: iby_trxn_extensions_v trxn_ext
4499: WHERE cr.request_id = l_request_id
4500: AND r.cash_receipt_id = cr.cash_receipt_id
4501: AND crh.cash_receipt_id = cr.cash_receipt_id
4502: AND crh.status = 'CONFIRMED'

Line 4522: iby_trxn_extensions_v trxn_ext

4518: SELECT
4519: cr.cash_receipt_id
4520: FROM ar_cash_receipts cr,
4521: ar_cash_receipt_history crh,
4522: iby_trxn_extensions_v trxn_ext
4523: WHERE cr.request_id = l_request_id
4524: AND crh.cash_receipt_id = cr.cash_receipt_id
4525: AND crh.status = 'CONFIRMED'
4526: AND crh.current_record_flag = 'Y'