[Home] [Help]
3382: | NOTES : None |
3383: | 12-Aug-2008 Pmarada bug Added code for OPM Financials to support AP PO |
3384: | reconciliation in R12, bug6995413 |
3385: | 21-nov-2008 pmarada, bug7516621, added nvl to the inventory_item_id in |
3386: | insert cst_reconciliation_gtt where clause, for expanse PO |
3387: | 05-Jul-2012 Uday Phadtare Bug 13630026.
3388: | Commented a join condition in the OPM query which is used for insering data into cst_reconciliation_gtt
3389: | so that all OPM receipt related data is loaded even if that join condition fails.
3390: | 22-Feb-2013 Uday Phadtare Bug 16277734.
3384: | reconciliation in R12, bug6995413 |
3385: | 21-nov-2008 pmarada, bug7516621, added nvl to the inventory_item_id in |
3386: | insert cst_reconciliation_gtt where clause, for expanse PO |
3387: | 05-Jul-2012 Uday Phadtare Bug 13630026.
3388: | Commented a join condition in the OPM query which is used for insering data into cst_reconciliation_gtt
3389: | so that all OPM receipt related data is loaded even if that join condition fails.
3390: | 22-Feb-2013 Uday Phadtare Bug 16277734.
3391: | Reinstated the join condition gel.line_id = xdl.source_distribution_id_num_1.
3392: +===========================================================================*/
3591: xla_security_pkg.set_security_context(p_application_id => 707);
3592:
3593: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3594:
3595: INSERT into cst_reconciliation_gtt
3596: (
3597: Transaction_date,
3598: Amount,
3599: Entered_amount,
3711: xla_security_pkg.set_security_context(p_application_id => 555);
3712:
3713: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3714:
3715: INSERT into cst_reconciliation_gtt
3716: (
3717: Transaction_date,
3718: Amount,
3719: Entered_amount,
3844:
3845: debug(' Inserting the AP data into the accrual table');
3846: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3847:
3848: Insert into cst_reconciliation_gtt
3849: (
3850: transaction_date,
3851: Amount,
3852: Entered_amount,
3989: debug(' Inserting the write off data into the accrual table');
3990:
3991: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
3992:
3993: Insert into cst_reconciliation_gtt
3994: (
3995: transaction_date,
3996: amount,
3997: entered_amount,
4081:
4082: /* There will be a hint added to force the GTT to use the index. This is required as the
4083: Temp table is a global temp table */
4084:
4085: debug(' populating CRS from cst_reconciliation_gtt');
4086:
4087: FORALL indx in po_dists_tab.FIRST..po_dists_tab.LAST
4088:
4089: Insert into CST_RECONCILIATION_SUMMARY
4110: program_application_id,
4111: program_id,
4112: program_update_date
4113: )
4114: SELECT /*+ INDEX(gtt, cst_reconciliation_gtt_n1) */
4115: gtt.po_distribution_id,
4116: gtt.accrual_account_id,
4117: SUM(decode(gtt.invoice_distribution_id,
4118: NULL,Decode(gtt.write_off_id,
4163: l_request_id,
4164: l_program_application_id,
4165: l_program_id,
4166: l_program_update_date
4167: FROM cst_reconciliation_gtt gtt
4168: WHERE gtt.operating_unit_id = p_operating_unit
4169: AND gtt.po_distribution_id = po_dists_tab(indx)
4170: AND gtt.build_id = l_build_id
4171: AND gtt.request_id = FND_GLOBAL.CONC_REQUEST_ID
4206: )
4207: ) <> 0 ;
4208:
4209:
4210: debug(' Done Inserting the new data into CRS from cst_reconciliation_gtt');
4211:
4212: l_stmt_num := 80;
4213: debug(' l_stmt_num :' ||l_stmt_num);
4214:
4290: l_program_update_date,
4291: gtt.ae_header_id,
4292: gtt.ae_line_num
4293: FROM
4294: cst_reconciliation_gtt gtt
4295: WHERE gtt.operating_unit_id = p_operating_unit
4296: AND gtt.po_distribution_id = po_dists_tab(indx)
4297: AND EXISTS (
4298: SELECT 1