APPS.AR_AUTOREC_API dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 1690: IBY_FNDCPT_TX_EXTENSIONS X,

1686: hz_customer_profiles site_cp,
1687: hz_cust_profile_amts cust_cpa,
1688: hz_cust_profile_amts site_cpa,
1689: ra_customer_trx ct,
1690: IBY_FNDCPT_TX_EXTENSIONS X,
1691: IBY_PMT_INSTR_USES_ALL U,
1692: IBY_FNDCPT_PMT_CHNNLS_B P,
1693: ar_payment_schedules ps,
1694: ar_payment_schedules_all ps1 ';

Line 2775: iby_fndcpt_tx_extensions ext

2771: SELECT crh.cash_receipt_id
2772: FROM ar_cash_receipt_history crh,
2773: ar_receivable_applications ra,
2774: ra_customer_trx ct,
2775: iby_fndcpt_tx_extensions ext
2776: WHERE crh.batch_id = p_batch_id
2777: AND crh.current_record_flag = 'Y'
2778: AND crh.status = 'CONFIRMED'
2779: AND ra.cash_receipt_id = crh.cash_receipt_id

Line 3368: iby_fndcpt_tx_extensions ext,

3364: trx_number||''-''||to_char(terms_sequence_number) trx_number,
3365: MAX(gt.cust_min_amount) cust_min_amount,
3366: null cash_receipt_id
3367: from ar_receipts_gt gt,
3368: iby_fndcpt_tx_extensions ext,
3369: hz_cust_accounts hca,
3370: ar_payment_schedules ps
3371: where ext.trxn_extension_id = gt.payment_trxn_extension_id
3372: and hca.cust_account_id = gt.paying_customer_id

Line 3426: iby_fndcpt_tx_extensions ext,

3422: null trx_number,
3423: gt.cust_min_amount,
3424: null cash_receipt_id
3425: from hz_cust_accounts hca,
3426: iby_fndcpt_tx_extensions ext,
3427: ( select paying_customer_id,
3428: payment_instrument,
3429: MIN(payment_trxn_extension_id) payment_trxn_extension_id,
3430: sum(amount_due_remaining) amount,

Line 3481: iby_fndcpt_tx_extensions ext,

3477: null trx_number,
3478: gt.cust_min_amount,
3479: null cash_receipt_id
3480: from hz_cust_accounts hca,
3481: iby_fndcpt_tx_extensions ext,
3482: ( select paying_customer_id,
3483: paying_site_use_id,
3484: payment_instrument,
3485: MIN(payment_trxn_extension_id) payment_trxn_extension_id,

Line 3560: iby_fndcpt_tx_extensions ext,

3556: null trx_number,
3557: gt.cust_min_amount,
3558: null cash_receipt_id
3559: from hz_cust_accounts hca,
3560: iby_fndcpt_tx_extensions ext,
3561: ( select paying_customer_id,
3562: paying_site_use_id,
3563: payment_instrument,
3564: due_date,

Line 3640: iby_fndcpt_tx_extensions ext,

3636: null trx_number,
3637: gt.cust_min_amount,
3638: null cash_receipt_id
3639: from hz_cust_accounts hca,
3640: iby_fndcpt_tx_extensions ext,
3641: ( select paying_customer_id,
3642: payment_instrument,
3643: due_date,
3644: MIN(payment_trxn_extension_id) payment_trxn_extension_id,

Line 3677: iby_fndcpt_tx_extensions ext,

3673: null trx_number,
3674: gt.cust_min_amount,
3675: null cash_receipt_id
3676: from hz_cust_accounts hca,
3677: iby_fndcpt_tx_extensions ext,
3678: ( select paying_customer_id,
3679: payment_trxn_extension_id,
3680: sum(amount_due_remaining) amount,
3681: customer_bank_account_id,

Line 3715: iby_fndcpt_tx_extensions ext,

3711: null trx_number,
3712: gt.cust_min_amount,
3713: null cash_receipt_id
3714: from hz_cust_accounts hca,
3715: iby_fndcpt_tx_extensions ext,
3716: ( select paying_customer_id,
3717: payment_trxn_extension_id,
3718: sum(amount_due_remaining) amount,
3719: payment_instrument,

Line 3750: iby_fndcpt_tx_extensions ext,

3746: null trx_number,
3747: gt.cust_min_amount,
3748: null cash_receipt_id
3749: from hz_cust_accounts hca,
3750: iby_fndcpt_tx_extensions ext,
3751: ( select paying_customer_id,
3752: payment_trxn_extension_id,
3753: sum(amount_due_remaining) amount,
3754: authorization_id,