DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on MTL_SECONDARY_INVENTORIES

Line 3021: FROM mtl_secondary_inventories s

3017:
3018: -- Bug 4165704: changed for inventory convergence
3019: CURSOR c_subinventory IS
3020: SELECT 1
3021: FROM mtl_secondary_inventories s
3022: WHERE s.organization_id = p_sample.organization_id
3023: AND s.secondary_inventory_name = p_sample.subinventory;
3024:
3025: -- Bug 4165704: changed for inventory convergence

Line 5038: FROM mtl_secondary_inventories

5034:
5035: CURSOR Cur_subinventory IS
5036: SELECT Locator_type, -- locator control
5037: description
5038: FROM mtl_secondary_inventories
5039: WHERE secondary_inventory_name = p_subinventory
5040: AND organization_id = p_organization_id;
5041:
5042: BEGIN

Line 5137: FROM mtl_secondary_inventories

5133: AND OTL.LANGUAGE = userenv('LANG');
5134:
5135: CURSOR Cur_locator_ctrl IS
5136: SELECT locator_type -- locator control
5137: FROM mtl_secondary_inventories
5138: WHERE organization_id = p_organization_id
5139: AND secondary_inventory_name = p_subinventory;
5140:
5141: