APPS.PO_SHARED_PROC_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 1156: FROM mtl_system_items_b msi,

1152: IF (p_item_revision IS NULL) THEN
1153: l_progress := '020';
1154: SELECT 'Y'
1155: INTO l_valid_flag
1156: FROM mtl_system_items_b msi,
1157: mtl_parameters mp
1158: WHERE msi.inventory_item_id = p_item_id
1159: AND msi.organization_id = p_inv_org_id
1160: AND mp.organization_id = msi.organization_id;

Line 1168: FROM mtl_system_items_b msi,

1164: --SQL What: Check that item and revision exist in dest org
1165: --SQL Why: To validate the item and revision
1166: SELECT 'Y'
1167: INTO l_valid_flag
1168: FROM mtl_system_items_b msi,
1169: mtl_item_revisions_b mir,
1170: mtl_parameters mp
1171: WHERE msi.inventory_item_id = p_item_id
1172: AND msi.organization_id = p_inv_org_id