eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_INV_VALUE_INIT_PKG dependencies on MTL_SYSTEM_ITEMS

Line 1091: FROM MTL_SUPPLY sup,MTL_SYSTEM_ITEMS msi_fm,mtl_units_of_measure um

1087: NULL,NULL), 0),
1088: NVL(to_org_primary_quantity, 0))) qty,
1089: item_id,
1090: cost_group_id
1091: FROM MTL_SUPPLY sup,MTL_SYSTEM_ITEMS msi_fm,mtl_units_of_measure um
1092: WHERE supply_type_code in ('SHIPMENT' , 'RECEIVING')
1093: AND intransit_owning_org_id IS NOT NULL
1094: AND msi_fm.organization_id = sup.from_organization_id
1095: AND msi_fm.inventory_item_id = sup.item_id

Line 1241: MTL_SYSTEM_ITEMS msi_fm,

1237: ),-1) cost_group_id
1238: FROM OPI_DBI_INTR_MMT_TMP mmt1,
1239: OPI_DBI_INTR_MIP_TMP mip,
1240: MTL_PARAMETERS mp,
1241: MTL_SYSTEM_ITEMS msi_fm,
1242: MTL_SYSTEM_ITEMS msi_to
1243: WHERE mmt1.organization_id = mip.from_organization_id
1244: AND mmt1.transfer_organization_id = mip.to_organization_id
1245: AND mmt1.transaction_action_id = mip.transaction_action_id

Line 1242: MTL_SYSTEM_ITEMS msi_to

1238: FROM OPI_DBI_INTR_MMT_TMP mmt1,
1239: OPI_DBI_INTR_MIP_TMP mip,
1240: MTL_PARAMETERS mp,
1241: MTL_SYSTEM_ITEMS msi_fm,
1242: MTL_SYSTEM_ITEMS msi_to
1243: WHERE mmt1.organization_id = mip.from_organization_id
1244: AND mmt1.transfer_organization_id = mip.to_organization_id
1245: AND mmt1.transaction_action_id = mip.transaction_action_id
1246: -- not collecting action id 24

Line 1285: MTL_SYSTEM_ITEMS msi,

1281: sum(sup.qty) tot_prim_qty,
1282: nvl (sup.cost_group_id, p.default_cost_group_id)
1283: cost_group_id
1284: FROM OPI_DBI_INTR_SUP_TMP sup,
1285: MTL_SYSTEM_ITEMS msi,
1286: MTL_PARAMETERS p
1287: WHERE sup.intransit_owning_org_id = msi.organization_id
1288: AND p.organization_id = msi.organization_id
1289: AND sup.item_id = msi.inventory_item_id

Line 1646: mtl_system_items msi_fm,

1642: sum (base_transaction_value) base_transaction_value
1643: from mtl_transaction_accounts
1644: where accounting_line_type = 14 -- Accounting line for Inransit in MTA
1645: group by transaction_id) mta,
1646: mtl_system_items msi_fm,
1647: mtl_system_items msi_to,
1648: opi_dbi_conc_prog_run_log col
1649: WHERE mmt1.organization_id = mip.from_organization_id
1650: AND mmt1.transfer_organization_id = mip.to_organization_id

Line 1647: mtl_system_items msi_to,

1643: from mtl_transaction_accounts
1644: where accounting_line_type = 14 -- Accounting line for Inransit in MTA
1645: group by transaction_id) mta,
1646: mtl_system_items msi_fm,
1647: mtl_system_items msi_to,
1648: opi_dbi_conc_prog_run_log col
1649: WHERE mmt1.organization_id = mip.from_organization_id
1650: AND mmt1.transfer_organization_id = mip.to_organization_id
1651: AND mmt1.transaction_action_id in (15,12,22,21)

Line 1691: mtl_system_items msi_fm,

1687: trunc(mmt1.transaction_date) trx_date,
1688: 'N' process_flag -- Bug fix: 5362465, source is only discrete here
1689: FROM opi_dbi_intr_mmt_tmp mmt1,
1690: mtl_transaction_accounts mta,
1691: mtl_system_items msi_fm,
1692: OPI_DBI_CONC_PROG_RUN_LOG col
1693: WHERE mmt1.transaction_action_id = 24
1694: AND mta.transaction_id = mmt1.transaction_id
1695: AND mmt1.organization_id = mta.organization_id

Line 1842: mtl_system_items msi_fm,

1838: AND (( gtv.accounted_flag IS NULL and gtv.final_posting_date < col.TO_BOUND_DATE )
1839: OR (gtv.accounted_flag ='D')) --
1840: GROUP BY transaction_id, accounted_flag
1841: ) gtv,
1842: mtl_system_items msi_fm,
1843: mtl_system_items msi_to
1844: WHERE mmt1.organization_id = mip.from_organization_id
1845: AND mmt1.transfer_organization_id = mip.to_organization_id
1846: AND mmt1.transaction_action_id in (15,12,22,21)

Line 1843: mtl_system_items msi_to

1839: OR (gtv.accounted_flag ='D')) --
1840: GROUP BY transaction_id, accounted_flag
1841: ) gtv,
1842: mtl_system_items msi_fm,
1843: mtl_system_items msi_to
1844: WHERE mmt1.organization_id = mip.from_organization_id
1845: AND mmt1.transfer_organization_id = mip.to_organization_id
1846: AND mmt1.transaction_action_id in (15,12,22,21)
1847: AND decode(mmt1.transaction_action_id,15,12,22,21,

Line 1990: -- ,MTL_SYSTEM_ITEMS MSI

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
1994: AND prl.etl_type (+)= 'INVENTORY'

Line 2036: ,MTL_SYSTEM_ITEMS MSI

2032: NULL source,
2033: 'MOQ' transaction_source
2034: FROM MTL_ONHAND_QUANTITIES MOQ
2035: ,MTL_PARAMETERS MP
2036: ,MTL_SYSTEM_ITEMS MSI
2037: WHERE moq.organization_id = mp.organization_id
2038: AND moq.organization_id = msi.organization_id
2039: AND moq.inventory_item_id = msi.inventory_item_id
2040: GROUP BY moq.organization_id,

Line 2629: mtl_system_items msi

2625: 0 wip_value_b_draft,
2626: 3 source
2627: FROM opi_dbi_opm_inv_stg
2628: ) activity,
2629: mtl_system_items msi
2630: WHERE activity.organization_id = msi.organization_id
2631: AND activity.inventory_item_id =msi.inventory_item_id
2632: group by
2633: activity.organization_id,