APPS.PO_VAL_SHIPMENTS2 dependencies on MTL_ITEM_REVISIONS

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

564: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
565: END IF;
566:
567: -- If item_id is not null and ship_to_organization_id is not null, and
568: -- item_revision is not null and no record exists in mtl_item_revisions.
569: FORALL i IN 1 .. p_id_tbl.COUNT
570: INSERT INTO po_validation_results_gt
571: (result_set_id,
572: result_type,

Line 597: FROM mtl_item_revisions mir

593: AND p_item_revision_tbl(i) IS NOT NULL
594: AND p_item_id_tbl(i) IS NOT NULL
595: AND NOT EXISTS(
596: SELECT 1
597: FROM mtl_item_revisions mir
598: WHERE mir.inventory_item_id = p_item_id_tbl(i)
599: AND mir.revision = p_item_revision_tbl(i)
600: AND mir.organization_id = p_ship_to_organization_id_tbl(i));
601:

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

605:
606: -- If item_id is not null and ship_to_organization_id is not null, and
607: -- item_revision is null, and no record exists in mtl_system_items.
608: -- Bug7513119 - Non revision controlled items were also getting validated
609: -- against mtl_item_revisions, changed this to mtl_system_items.
610: FORALL i IN 1 .. p_id_tbl.COUNT
611: INSERT INTO po_validation_results_gt
612: (result_set_id,
613: result_type,