[Home] [Help]
256: sum(mta.base_transaction_value) base_transaction_value
257: FROM mtl_transaction_accounts mta,
258: mtl_material_transactions mmt3,
259: opi_dbi_conc_prog_run_log prl,
260: mtl_parameters mp
261: WHERE mta.accounting_line_type = 1
262: AND mta.transaction_id >= prl.from_bound_id
263: AND mta.transaction_id < to_bound_id
264: AND prl.etl_type = 'INVENTORY'
287: mmt.inventory_item_id,
288: trunc(mmt.transaction_date) transaction_date,
289: nvl(sum(decode(mmt.transaction_action_id,24,0,mmt.primary_quantity)),0) onhand_qty
290: FROM mtl_material_transactions mmt,
291: mtl_parameters mp,
292: opi_dbi_conc_prog_run_log prl
293: WHERE prl.etl_type = 'INVENTORY'
294: AND prl.load_type = 'INCR'
295: AND prl.driving_table_code = 'MMT'
530: -- R12 changes.
531: -- 1. Handle intransit across Process and discrete orgs.
532: -- 2. log table is modified
533: --
534: -- mip has two records for each setup in mtl_parameters.
535: -- e.g. for M1 -> M2 FOB = 2 there are two records in mip
536: -- from_org to_org owning_org txn_action_id
537: -- M1 M2 M1 21
538: -- M2 M1 M1 12
634: group by transaction_id) mta,
635: mtl_system_items msi_fm,
636: mtl_system_items msi_to,
637: OPI_DBI_CONC_PROG_RUN_LOG col,
638: MTL_PARAMETERS mp
639: WHERE mmt1.organization_id = mip.from_organization_id
640: AND mmt1.transfer_organization_id = mip.to_organization_id
641: AND mmt1.transaction_action_id in (15,12,22,21)
642: AND decode(mmt1.transaction_action_id,15,12,22,21,mmt1.transaction_action_id) = mip.transaction_action_id
839: Group by transaction_id, accounted_flag
840: ) gtv,
841: mtl_system_items msi_fm,
842: mtl_system_items msi_to,
843: mtl_parameters mp
844: WHERE mmt1.organization_id = mip.from_organization_id
845: AND mmt1.transfer_organization_id = mip.to_organization_id
846: AND mmt1.transaction_action_id in (15,12,22,21)
847: AND decode(mmt1.transaction_action_id,15,12,22,21,