APPS.GMPRELAP dependencies on MTL_SYSTEM_ITEMS

Line 139: mtl_system_items mtl

135: gmp.header_id,
136: gmp.scheduling_method,
137: gmp.rowid
138: FROM gmp_aps_output_tbl gmp,
139: mtl_system_items mtl
140: WHERE gmp.processed_ind > 0
141: AND gmp.process_id = nvl(c_process_id,gmp.process_id) /* vpedarla bug: 7258717 */
142: AND gmp.inventory_item_id = mtl.inventory_item_id
143: AND gmp.organization_id = mtl.organization_id

Line 512: (select PRIMARY_UOM_CODE, inventory_item_id , organization_id from mtl_system_items) msi,

508:
509: -- Bug: 8625112 Vpedarla
510: CURSOR Cur_get_item_uoms IS
511: SELECT msi.PRIMARY_UOM_CODE , gmd.detail_uom from
512: (select PRIMARY_UOM_CODE, inventory_item_id , organization_id from mtl_system_items) msi,
513: (select inventory_item_id , recipe_validity_rule_id , DETAIL_UOM from gmd_recipe_validity_rules ) gmd
514: where msi.organization_id = p_organization_id
515: AND msi.inventory_item_id = p_inventory_item_id
516: AND msi.inventory_item_id = gmd.inventory_item_id

Line 1144: (select PRIMARY_UOM_CODE, inventory_item_id , organization_id , CONCATENATED_SEGMENTS from mtl_system_items_kfv) msi,

1140:
1141: -- Bug: 8663941 Vpedarla
1142: CURSOR Cur_get_item_uoms(eff_id NUMBER) IS
1143: SELECT msi.CONCATENATED_SEGMENTS , msi.inventory_item_id from
1144: (select PRIMARY_UOM_CODE, inventory_item_id , organization_id , CONCATENATED_SEGMENTS from mtl_system_items_kfv) msi,
1145: (select inventory_item_id , recipe_validity_rule_id , DETAIL_UOM from gmd_recipe_validity_rules ) gmd
1146: where msi.organization_id = p_organization_id
1147: AND msi.inventory_item_id = gmd.inventory_item_id
1148: AND gmd.recipe_validity_rule_id = eff_id ;