APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 488: FROM mtl_material_transactions mmt,

484: mmt.organization_id,
485: mmt.inventory_item_id,
486: NULL cost_group_id, --RS: Bug fix 5219487 nvl (mmt.cost_group_id, p.default_cost_group_id) cost_group_id,
487: min(mmt.transaction_id) trx_id
488: FROM mtl_material_transactions mmt,
489: OPI_DBI_INV_BEG_STG stg,
490: mtl_parameters p
491: WHERE primary_cost_method = 1
492: AND stg.organization_id = p.organization_id

Line 515: mtl_material_transactions mmt2

511: mmt.inventory_item_id -- ,
512: -- nvl (mmt.cost_group_id, p.default_cost_group_id), --RS: Bug fix 5219487
513: -- p.primary_cost_method
514: ) mmt1,
515: mtl_material_transactions mmt2
516: WHERE mmt2.transaction_id = mmt1.trx_id
517: and fact.organization_id = mmt1.organization_id
518: and fact.inventory_item_id =mmt1.inventory_item_id
519: -- and fact.cost_group_id =mmt1.cost_group_id -- RS: Bug fix 5219487

Line 580: FROM mtl_material_transactions mmt,

576: mmt.inventory_item_id,
577: nvl (mmt.cost_group_id, p.default_cost_group_id) cost_group_id,
578: p.primary_cost_method cost_method,
579: min(mmt.transaction_id) trx_id
580: FROM mtl_material_transactions mmt,
581: OPI_DBI_INV_BEG_STG stg,
582: mtl_parameters p
583: WHERE primary_cost_method <> 1
584: AND stg.organization_id = p.organization_id

Line 598: mtl_material_transactions mmt2

594: mmt.inventory_item_id,
595: nvl (mmt.cost_group_id, p.default_cost_group_id),
596: p.primary_cost_method
597: ) mmt1,
598: mtl_material_transactions mmt2
599: WHERE mmt2.transaction_id = mmt1.trx_id
600: and fact.organization_id = mmt1.organization_id
601: and fact.inventory_item_id =mmt1.inventory_item_id
602: and fact.cost_group_id =mmt1.cost_group_id

Line 1044: FROM MTL_MATERIAL_TRANSACTIONS mmt,

1040: DECODE (mmt.transaction_action_id,
1041: 24, 0,
1042: mmt.primary_quantity),
1043: transaction_date
1044: FROM MTL_MATERIAL_TRANSACTIONS mmt,
1045: MTL_PARAMETERS p,
1046: MTL_PARAMETERS p1
1047: WHERE mmt.transaction_action_id in (12,21,24,15,22)
1048: AND mmt.transaction_date >= g_global_start_date

Line 1989: FROM MTL_MATERIAL_TRANSACTIONS MMT

1985: ELSE 'N'
1986: END push_to_fact_flag,
1987: DECODE(mp.process_enabled_flag,'N',1,'Y',2,1) source,
1988: 'MMT' transaction_source
1989: FROM MTL_MATERIAL_TRANSACTIONS MMT
1990: -- ,MTL_SYSTEM_ITEMS MSI
1991: ,OPI_DBI_CONC_PROG_RUN_LOG PRL
1992: ,MTL_PARAMETERS MP
1993: WHERE prl.driving_table_code (+)= 'MMT' --bug 4704813

Line 2151: ,mtl_material_transactions mmt

2147: else 'N'
2148: end push_to_fact_flag,
2149: 'MTA' transaction_source
2150: FROM mtl_transaction_accounts mta
2151: ,mtl_material_transactions mmt
2152: ,wip_entities we
2153: ,opi_dbi_conc_prog_run_log prl
2154: WHERE prl.driving_table_code = 'MMT'
2155: AND prl.etl_type = 'INVENTORY'