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 1561: FROM mtl_parameters

1557:
1558: -- Get Value of Org_Locator and item_Locator.
1559: SELECT stock_locator_control_code
1560: INTO l_org_locator_control
1561: FROM mtl_parameters
1562: WHERE organization_id = p_organization_id;
1563:
1564: -- Get Value of Item Locator
1565: SELECT location_control_code