DBA Data[Home] [Help]

APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on MTL_SYSTEM_ITEMS

Line 423: mtl_system_items msi

419: nvl(gtv.subinventory_code,-1),
420: gtv.accounted_flag
421: ) gtv,
422: mtl_material_transactions mmt,
423: mtl_system_items msi
424: WHERE mmt.transaction_id = gtv.transaction_id
425: AND mmt.inventory_item_id = msi.inventory_item_id
426: AND mmt.organization_id = msi.organization_id
427: GROUP BY mmt.organization_id,

Line 635: mtl_system_items msi_fm,

631: where accounting_line_type = 14
632: AND transaction_id >= from_mta_id --BOUNDS COLLECTED ABOVE
633: ANd transaction_id < to_mta_id
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

Line 636: mtl_system_items msi_to,

632: AND transaction_id >= from_mta_id --BOUNDS COLLECTED ABOVE
633: ANd transaction_id < to_mta_id
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

Line 680: mtl_system_items msi_fm,

676: msi_fm.primary_uom_code,
677: trunc(mmt1.transaction_date) trx_date
678: FROM mtl_material_transactions mmt1,
679: mtl_transaction_accounts mta,
680: mtl_system_items msi_fm,
681: OPI_DBI_CONC_PROG_RUN_LOG col
682: WHERE mmt1.transaction_action_id = 24
683: AND mta.transaction_id = mmt1.transaction_id
684: AND mmt1.organization_id = mta.organization_id

Line 841: mtl_system_items msi_fm,

837: and gtv.organization_id = tmp. organization_id
838: AND gtv.accounted_flag ='D' --
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

Line 842: mtl_system_items msi_to,

838: AND gtv.accounted_flag ='D' --
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)

Line 1009: mtl_system_items_b msi

1005: wta.organization_id,
1006: we.primary_item_id,
1007: wta.transaction_date
1008: ) wip_activity,
1009: mtl_system_items_b msi
1010: WHERE msi.organization_id = wip_activity.organization_id
1011: AND wip_activity.inventory_item_id = msi.inventory_item_id
1012: GROUP BY
1013: wip_activity.organization_id,

Line 1121: mtl_system_items_b msi

1117: gmdtl.organization_id,
1118: gmdtl.inventory_item_id,
1119: trunc (gtv.transaction_date)
1120: ) wip_activity,
1121: mtl_system_items_b msi
1122: WHERE msi.organization_id = wip_activity.organization_id
1123: AND wip_activity.inventory_item_id = msi.inventory_item_id
1124: GROUP BY
1125: wip_activity.organization_id,

Line 1252: (SELECT /*+ index (msi MTL_SYSTEM_ITEMS_B_U1) */

1248: s.INTRANSIT_VALUE_B_DRAFT,
1249: s.WIP_VALUE_B_DRAFT,
1250: source
1251: FROM
1252: (SELECT /*+ index (msi MTL_SYSTEM_ITEMS_B_U1) */
1253: activity.organization_id,
1254: activity.subinventory_code,
1255: activity.inventory_item_id,
1256: activity.transaction_date,

Line 1327: mtl_system_items msi

1323: wip_value_b_draft,
1324: source
1325: from opi_dbi_wip_stg
1326: ) activity,
1327: mtl_system_items msi
1328: WHERE activity.organization_id = msi.organization_id
1329: AND activity.inventory_item_id =msi.inventory_item_id
1330: group by
1331: activity.organization_id,