APPS.ENG_VALIDATE_REVISED_ITEM dependencies on MTL_PARAMETERS

Line 627: FROM MTL_PARAMETERS mp

623: -- Added by MK on 11/27/00
624: IF NO_ECO_ROUTING_REV%NOTFOUND THEN
625: SELECT mp.starting_revision
626: INTO l_current_revision
627: FROM MTL_PARAMETERS mp
628: WHERE mp.organization_id = p_organization_id
629: AND NOT EXISTS( SELECT NULL
630: FROM MTL_RTG_ITEM_REVISIONS
631: WHERE implementation_date IS NOT NULL

Line 1496: FROM mtl_parameters

1492:
1493: -- Get Value of Org_Locator and item_Locator.
1494: SELECT stock_locator_control_code
1495: INTO l_org_locator_control
1496: FROM mtl_parameters
1497: WHERE organization_id = p_organization_id;
1498:
1499: -- Get Value of Item Locator
1500: SELECT location_control_code