APPS.PO_VAL_LINES2 dependencies on MTL_ITEM_REVISIONS

Line 1497: -- be NULL. Check to see if there are x_item_revision exists in mtl_item_revisions table

1493: END unit_meas_lookup_code;
1494:
1495: -------------------------------------------------------------------------
1496: -- If order_type_lookup_code is FIXED PRICE or RATE, or item id is null, then item revision has to
1497: -- be NULL. Check to see if there are x_item_revision exists in mtl_item_revisions table
1498: -------------------------------------------------------------------------
1499: PROCEDURE item_revision(
1500: p_id_tbl IN po_tbl_number,
1501: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

Line 1541: -- check to see if there are x_item_revision exists in mtl_item_revisions

1537: x_result_type := po_validations.c_result_type_failure;
1538: END IF;
1539: END LOOP;
1540:
1541: -- check to see if there are x_item_revision exists in mtl_item_revisions
1542: -- table
1543: FORALL i IN 1 .. p_id_tbl.COUNT
1544: INSERT INTO po_validation_results_gt
1545: (result_set_id,

Line 1578: FROM mtl_item_revisions mir

1574: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1575: AND p_item_revision_tbl(i) IS NOT NULL
1576: AND p_item_id_tbl(i) IS NOT NULL
1577: AND NOT EXISTS(SELECT 1
1578: FROM mtl_item_revisions mir
1579: WHERE mir.inventory_item_id = p_item_id_tbl(i)
1580: AND mir.revision = p_item_revision_tbl(i));
1581:
1582: IF (SQL%ROWCOUNT > 0) THEN