APPS.ARP_XLA_EXTRACT_MAIN_PKG dependencies on AR_CRH_APP_GT

Line 4619: DELETE FROM ar_crh_app_gt;

4615: mfar_produit_app_by_crh;
4616: --Create additional_distribution_for_ra
4617: mfar_get_ra;
4618: --Avoid contention between Cash Receipt and MCD
4619: DELETE FROM ar_crh_app_gt;
4620: -- Get all Misc Cash Distributions for the Misc receipts
4621: mfar_mcd_dist_cr;
4622: -- Create the times of addition distribution for MCD
4623: mfar_produit_mcd_by_crh;

Line 5809: | table ar_crh_app_gt.

5805: | Procedure Name : mfar_app_dist_cr
5806: | Description : Fetches all the application distributions for RECP_CREATE,
5807: | RECP_UPDATE and RECP_RATE_ADJUST events which are necessary
5808: | for the MFAR CRH building and populates the GT
5809: | table ar_crh_app_gt.
5810: +-------------------------------------------------------------------------------+
5811: | History :
5812: | 25-JUL-2010 Anshu Kaushal Created
5813: +------------------------------------------------------------------------------*/

Line 5823: INSERT INTO ar_crh_app_gt (

5819: --
5820: -- For a RECP_CREATE and RECP_UPDATE events
5821: -- All application distributions are necessary for the MFAR CRH building
5822: --
5823: INSERT INTO ar_crh_app_gt (
5824: entity_id
5825: ,receivable_application_id
5826: ,cash_receipt_history_id
5827: ,cash_receipt_history_status

Line 6214: | of the lines in the Gt tables ar_crh_gt and ar_crh_app_gt.

6210:
6211: /*-------------------------------------------------------------------------------+
6212: | Procedure Name : mfar_produit_app_by_crh
6213: | Description : Builds the MFAR distributions for CRH by taking a cross product
6214: | of the lines in the Gt tables ar_crh_gt and ar_crh_app_gt.
6215: | Calls the procedure to insert into the extract table after
6216: | building the CRH MFAR distributions.
6217: +-------------------------------------------------------------------------------+
6218: | History :

Line 6314: ar_crh_app_gt app,

6310: ,app.from_currency_code))) ALLOC_ACCTD_AMOUNT
6311: ,decode(crh.dist_line_status, 'REVERSAL', -1*app_max_line.max_line_id, app_max_line.max_line_id)
6312: ,app.mfar_upg_trx
6313: FROM ar_crh_gt crh,
6314: ar_crh_app_gt app,
6315: xla_events_gt gt,
6316: (SELECT app1.receivable_application_id receivable_application_id,
6317: MAX(app1.line_id) max_line_id
6318: FROM ar_crh_app_gt app1

Line 6318: FROM ar_crh_app_gt app1

6314: ar_crh_app_gt app,
6315: xla_events_gt gt,
6316: (SELECT app1.receivable_application_id receivable_application_id,
6317: MAX(app1.line_id) max_line_id
6318: FROM ar_crh_app_gt app1
6319: GROUP BY app1.receivable_application_id) app_max_line
6320: WHERE crh.entity_id = app.entity_id
6321: AND app.source_table = 'RA'
6322: and app.receivable_application_id = app_max_line.receivable_application_id

Line 7169: INSERT INTO ar_crh_app_gt (

7165: PROCEDURE mfar_mcd_dist_cr IS
7166: BEGIN
7167: local_log(procedure_name => 'mfar_mcd_dist_cr',
7168: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_mcd_dist_cr ()+');
7169: INSERT INTO ar_crh_app_gt (
7170: entity_id
7171: ,receivable_application_id
7172: ,cash_receipt_history_id
7173: ,cash_receipt_history_status

Line 7413: ar_crh_app_gt mcd,

7409: ,gt.event_type_code --EVENT_TYPE_CODE
7410: ,gt.event_class_code --EVENT_CLASS_CODE
7411: ,gt.entity_code --ENTITY_CODE
7412: FROM ar_crh_gt crh,
7413: ar_crh_app_gt mcd,
7414: xla_events_gt gt
7415: WHERE crh.entity_id = mcd.entity_id
7416: AND mcd.source_table = 'MCD'
7417: AND crh.event_id = gt.event_id;