APPS.PO_VAL_SHIPMENTS2 dependencies on MTL_ITEM_REVISIONS

Line 932: -- item_revision is not null and no record exists in mtl_item_revisions.

928: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
929: END IF;
930:
931: -- If item_id is not null and ship_to_organization_id is not null, and
932: -- item_revision is not null and no record exists in mtl_item_revisions.
933: FORALL i IN 1 .. p_id_tbl.COUNT
934: INSERT INTO po_validation_results_gt
935: (result_set_id,
936: result_type,

Line 961: FROM mtl_item_revisions mir

957: AND p_item_revision_tbl(i) IS NOT NULL
958: AND p_item_id_tbl(i) IS NOT NULL
959: AND NOT EXISTS(
960: SELECT 1
961: FROM mtl_item_revisions mir
962: WHERE mir.inventory_item_id = p_item_id_tbl(i)
963: AND mir.revision = p_item_revision_tbl(i)
964: AND mir.organization_id = p_ship_to_organization_id_tbl(i));
965:

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,