[Home] [Help]
5967: | Procedure Name : mfar_crh_dist
5968: | Description : Fetches all the CRH distributions for RECP_CREATE, RECP_UPDATE
5969: | MISC_RECP_CREATE, MISC_RECP_UPDATE, RECP_RATE_ADJUST events
5970: | which are necessary for MFAR additional distribution building
5971: | and populates the GT table ar_crh_gt.
5972: +-------------------------------------------------------------------------------+
5973: | History :
5974: | 25-JUL-2010 Anshu Kaushal Created
5975: +------------------------------------------------------------------------------*/
5979: local_log(procedure_name => 'mfar_crh_dist',
5980: p_msg_text => 'ARP_XLA_EXTRACT_MAIN_PKG.mfar_crh_dist ()+');
5981: -- All CRH distribution part of the current posting will serve for the
5982: -- Additional distribution building
5983: INSERT INTO ar_crh_gt (
5984: cash_receipt_id ,
5985: cash_receipt_history_id,
5986: source_type ,
5987: posting_control_id ,
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 :
6309: ar_unposted_item_util.currRound((decode(crh.DIST_LINE_STATUS,'REVERSAL', crh.acctd_amount, -1*(crh.acctd_amount))/crh.recp_acctd_amount) * app.acctd_amount_applied
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
6831: ra_cust_trx_line_gl_dist_all ctlgd,
6832: ra_customer_trx_lines_all ctl,
6833: ar_cash_receipts_all cr,
6834: gl_ledgers lg,
6835: ar_crh_gt crhgt,
6836: (SELECT source_id,
6837: MAX(line_id) max_line_id
6838: FROM ar_xla_lines_extract
6839: WHERE source_table='RA'
7408: --
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'