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_JOB_TXN_STG_PKG dependencies on MTL_SYSTEM_ITEMS_B

Line 730: mtl_system_items_b msi,

726: 30,3) ETL_TYPE_ID
727: from
728: OPI_DBI_JOBS_TXN_MMT_STG mmt,
729: mtl_material_txn_allocations mmta,
730: mtl_system_items_b msi,
731: OPI_DBI_RUN_LOG_CURR log
732: where
733: mmt.organization_id = msi.organization_id and
734: mmt.inventory_item_id = msi.inventory_item_id and

Line 971: mtl_system_items_b msi,

967: 30,3) ETL_TYPE_ID
968: from
969: MTL_MATERIAL_TRANSACTIONS mmt,
970: mtl_material_txn_allocations mmta,
971: mtl_system_items_b msi,
972: OPI_DBI_RUN_LOG_CURR log
973: where
974: mmt.organization_id = msi.organization_id and
975: mmt.inventory_item_id = msi.inventory_item_id and

Line 1207: mtl_system_items_b msi

1203: gtv.accounted_flag
1204: ) GTV,
1205: GME_MATERIAL_DETAILS MTL_DTL,
1206: OPI_DBI_JOBS_TXN_MMT_STG MMT_STG,
1207: mtl_system_items_b msi
1208: where
1209: GTV.organization_id = MTL_DTL.organization_id and
1210: GTV.doc_id = MTL_DTL.batch_id and
1211: MTL_DTL.line_type = 1 and --Product

Line 1428: mtl_system_items_b msi

1424: gtv.accounted_flag
1425: ) GTV,
1426: GME_MATERIAL_DETAILS MTL_DTL,
1427: MTL_MATERIAL_TRANSACTIONS MMT_STG,
1428: mtl_system_items_b msi
1429: where
1430: GTV.organization_id = MTL_DTL.organization_id and
1431: GTV.doc_id = MTL_DTL.batch_id and
1432: MTL_DTL.line_type = 1 and -- Products

Line 1712: mtl_system_items_b msi

1708: sub.line_id,
1709: TRUNC(sub.gl_trans_date)
1710: ) led,
1711: GME_MATERIAL_DETAILS mtl_dtl,
1712: mtl_system_items_b msi
1713: WHERE
1714: itp.doc_type = led.doc_type AND
1715: itp.doc_id = led.doc_id AND
1716: itp.line_id = led.line_id AND