APPS.PO_VAL_SHIPMENTS2 dependencies on MTL_SYSTEM_ITEMS

Line 971: -- item_revision is null, and no record exists in mtl_system_items.

967: x_result_type := po_validations.c_result_type_failure;
968: END IF;
969:
970: -- If item_id is not null and ship_to_organization_id is not null, and
971: -- item_revision is null, and no record exists in mtl_system_items.
972: -- Bug7513119 - Non revision controlled items were also getting validated
973: -- against mtl_item_revisions, changed this to mtl_system_items.
974: FORALL i IN 1 .. p_id_tbl.COUNT
975: INSERT INTO po_validation_results_gt

Line 973: -- against mtl_item_revisions, changed this to mtl_system_items.

969:
970: -- If item_id is not null and ship_to_organization_id is not null, and
971: -- item_revision is null, and no record exists in mtl_system_items.
972: -- Bug7513119 - Non revision controlled items were also getting validated
973: -- against mtl_item_revisions, changed this to mtl_system_items.
974: FORALL i IN 1 .. p_id_tbl.COUNT
975: INSERT INTO po_validation_results_gt
976: (result_set_id,
977: result_type,

Line 1001: FROM mtl_system_items msi --Bug7513119

997: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
998: AND p_item_revision_tbl(i) IS NULL
999: AND p_item_id_tbl(i) IS NOT NULL
1000: AND NOT EXISTS(SELECT 1
1001: FROM mtl_system_items msi --Bug7513119
1002: WHERE msi.inventory_item_id = p_item_id_tbl(i)
1003: AND msi.organization_id = p_ship_to_organization_id_tbl(i));
1004:
1005: