DBA Data[Home] [Help]

APPS.PO_VAL_SHIPMENTS2 dependencies on MTL_SYSTEM_ITEMS

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

603: x_result_type := po_validations.c_result_type_failure;
604: END IF;
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

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,

Line 637: FROM mtl_system_items msi --Bug7513119

633: WHERE p_ship_to_organization_id_tbl(i) IS NOT NULL
634: AND p_item_revision_tbl(i) IS NULL
635: AND p_item_id_tbl(i) IS NOT NULL
636: AND NOT EXISTS(SELECT 1
637: FROM mtl_system_items msi --Bug7513119
638: WHERE msi.inventory_item_id = p_item_id_tbl(i)
639: AND msi.organization_id = p_ship_to_organization_id_tbl(i));
640:
641: