APPS.AR_AUTOREC_API dependencies on IBY_FNDCPT_TX_OPERATIONS

Line 2340: iby_fndcpt_tx_operations op,

2336: SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ r.customer_trx_id
2337: FROM ar_receipts_gt r,
2338: ar_cash_receipts cr,
2339: ar_cash_receipt_history crh,
2340: iby_fndcpt_tx_operations op,
2341: iby_trxn_summaries_all summ
2342: WHERE r.gt_id = p_gt_id
2343: AND cr.cash_receipt_id = r.cash_receipt_id
2344: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 2372: iby_fndcpt_tx_operations op,

2368: ( SELECT /*+ LEADING(R) INDEX (R, AR_RECEIPTS_GT_N1) USE_NL(R, CR) */ cr.cash_receipt_id
2369: FROM ar_receipts_gt r,
2370: ar_cash_receipts cr,
2371: ar_cash_receipt_history crh,
2372: iby_fndcpt_tx_operations op,
2373: iby_trxn_summaries_all summ
2374: WHERE r.gt_id = p_gt_id
2375: AND cr.cash_receipt_id = r.cash_receipt_id
2376: AND crh.cash_receipt_id = cr.cash_receipt_id

Line 5198: iby_fndcpt_tx_operations op

5194: ar_cash_receipts cr,
5195: ar_cash_receipt_history crh,
5196: (SELECT op.trxn_extension_id, summ.status
5197: FROM iby_trxn_summaries_all summ,
5198: iby_fndcpt_tx_operations op
5199: WHERE(summ.transactionid = op.transactionid)
5200: AND(reqtype = 'ORAPMTREQ')
5201: AND(status IN(0, 100, 111, 31, 32))
5202: AND((trxntypeid IN(2, 3)) OR((trxntypeid = 20)

Line 5258: iby_fndcpt_tx_operations op

5254: ar_cash_receipts cr,
5255: ar_cash_receipt_history crh,
5256: (SELECT op.trxn_extension_id, summ.status
5257: FROM iby_trxn_summaries_all summ,
5258: iby_fndcpt_tx_operations op
5259: WHERE(summ.transactionid = op.transactionid)
5260: AND(reqtype = 'ORAPMTREQ')
5261: AND(status IN(0, 100, 111, 31, 32))
5262: AND((trxntypeid IN(2, 3)) OR((trxntypeid = 20)