APPS.PO_VAL_LINES2 dependencies on MTL_ITEM_REVISIONS

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

1502: END unit_meas_lookup_code;
1503:
1504: -------------------------------------------------------------------------
1505: -- If order_type_lookup_code is FIXED PRICE or RATE, or item id is null, then item revision has to
1506: -- be NULL. Check to see if there are x_item_revision exists in mtl_item_revisions table
1507: -------------------------------------------------------------------------
1508: PROCEDURE item_revision(
1509: p_id_tbl IN po_tbl_number,
1510: p_order_type_lookup_code_tbl IN po_tbl_varchar30,

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

1546: x_result_type := po_validations.c_result_type_failure;
1547: END IF;
1548: END LOOP;
1549:
1550: -- check to see if there are x_item_revision exists in mtl_item_revisions
1551: -- table
1552: FORALL i IN 1 .. p_id_tbl.COUNT
1553: INSERT INTO po_validation_results_gt
1554: (result_set_id,

Line 1587: FROM mtl_item_revisions mir

1583: WHERE p_order_type_lookup_code_tbl(i) NOT IN('RATE', 'FIXED PRICE')
1584: AND p_item_revision_tbl(i) IS NOT NULL
1585: AND p_item_id_tbl(i) IS NOT NULL
1586: AND NOT EXISTS(SELECT 1
1587: FROM mtl_item_revisions mir
1588: WHERE mir.inventory_item_id = p_item_id_tbl(i)
1589: AND mir.revision = p_item_revision_tbl(i));
1590:
1591: IF (SQL%ROWCOUNT > 0) THEN