APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_LINE_APP_DETAIL_GT

Line 421: FROM ar_line_app_detail_gt b,

417: ,CASE WHEN (NVL(a.acctd_amount_cr,0) - NVL(a.acctd_amount_dr,0)) > 0 THEN
418: ABS(b.from_acctd_amount) ELSE NULL END
419: ,b.activity_bucket
420: ,b.line_id
421: FROM ar_line_app_detail_gt b,
422: ar_distributions_all a
423: WHERE b.line_id = a.line_id;
424:
425: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;

Line 487: FROM ar_line_app_detail_gt

483: det_id, --cash_receipt_id
484: group_id, --customer_trx_id CM
485: gt_id, --receivable_application_id used also as gt_id
486: to_currency --invoice currency
487: FROM ar_line_app_detail_gt
488: GROUP BY
489: (taxable_amount, --amount_applied_from
490: taxable_acctd_amount, --acctd_amount_applied_from
491: base_currency, --sob_currency

Line 515: INSERT INTO ar_line_app_detail_gt

511: --Get 11i Applications to upgrade
512:
513: local_log(procedure_name => 'upgrade_11i_r12_post',
514: p_msg_text => ' Get 11i application to upgrade');
515: INSERT INTO ar_line_app_detail_gt
516: (gt_id, --receivable_application_id
517: source_data_key1, --application_type CASH CM
518: det_id, --cash_receipt_id CASH
519: group_id, --customer_trx_id CM

Line 622: FROM ar_line_app_detail_gt

618: UPDATE ar_receivable_applications_all
619: SET upgrade_method = '11I_R12_POST'
620: WHERE receivable_application_id IN
621: (SELECT gt_id
622: FROM ar_line_app_detail_gt
623: GROUP BY gt_id);
624: END IF;
625:
626: local_log(procedure_name => 'upgrade_11i_r12_post',