APPS.PO_ITEMS_SV2 dependencies on MTL_SYSTEM_ITEMS

Line 70: FROM mtl_system_items msi , mtl_units_of_measure mum

66: X_secondary_default_ind ,
67: X_grade_control_flag ,
68: X_secondary_unit_of_measure
69: /* INVCONV END PBAMB */
70: FROM mtl_system_items msi , mtl_units_of_measure mum
71: WHERE inventory_item_id = X_item_id
72: AND organization_id = X_inventory_organization_id
73: AND mum.uom_code(+) = msi.secondary_uom_code;
74:

Line 120: FROM mtl_system_items msi

116:
117: SELECT decode(msi.outside_operation_flag,'Y','O',
118: decode(msi.stock_enabled_flag,'Y','E','D'))
119: INTO X_item_status
120: FROM mtl_system_items msi
121: WHERE msi.organization_id = X_ship_org_id
122: AND msi.inventory_item_id = X_item_id;
123:
124:

Line 271: FROM mtl_system_items_kfv msi

267: X_progress := 400;
268:
269: SELECT msi.revision_qty_control_code
270: INTO X_item_rev_control
271: FROM mtl_system_items_kfv msi
272: WHERE X_item_id = msi.inventory_item_id
273: AND X_to_organization_id = msi.organization_id;
274:
275: /* Express transactions were erroring out when item revision control was 1 and