APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_LINE_APP_DETAIL_GT

Line 82: FROM ar_line_app_detail_gt b,

78: ,CASE WHEN (NVL(a.acctd_amount_cr,0) - NVL(a.acctd_amount_dr,0)) > 0 THEN
79: ABS(b.from_acctd_amount) ELSE NULL END
80: ,b.activity_bucket
81: ,b.line_id
82: FROM ar_line_app_detail_gt b,
83: ar_distributions_all a
84: WHERE b.line_id = a.line_id;
85:
86: l_from_amount_dr DBMS_SQL.NUMBER_TABLE;

Line 148: FROM ar_line_app_detail_gt

144: det_id, --cash_receipt_id
145: group_id, --customer_trx_id CM
146: gt_id, --receivable_application_id used also as gt_id
147: to_currency --invoice currency
148: FROM ar_line_app_detail_gt
149: GROUP BY
150: (taxable_amount, --amount_applied_from
151: taxable_acctd_amount, --acctd_amount_applied_from
152: base_currency, --sob_currency

Line 176: INSERT INTO ar_line_app_detail_gt

172: --Get 11i Applications to upgrade
173:
174: local_log(procedure_name => 'upgrade_11i_r12_post',
175: p_msg_text => ' Get 11i application to upgrade');
176: INSERT INTO ar_line_app_detail_gt
177: (gt_id, --receivable_application_id
178: source_data_key1, --application_type CASH CM
179: det_id, --cash_receipt_id CASH
180: group_id, --customer_trx_id CM

Line 282: FROM ar_line_app_detail_gt

278: UPDATE ar_receivable_applications_all
279: SET upgrade_method = '11I_R12_POST'
280: WHERE receivable_application_id IN
281: (SELECT gt_id
282: FROM ar_line_app_detail_gt
283: GROUP BY gt_id);
284: END IF;
285:
286: local_log(procedure_name => 'upgrade_11i_r12_post',