DBA Data[Home] [Help]

APPS.GMD_SAMPLES_GRP dependencies on MTL_SECONDARY_INVENTORIES

Line 3616: FROM mtl_secondary_inventories s

3612:
3613: -- Bug 4165704: changed for inventory convergence
3614: CURSOR c_subinventory IS
3615: SELECT 1
3616: FROM mtl_secondary_inventories s
3617: WHERE s.organization_id = p_sample.organization_id
3618: AND s.secondary_inventory_name = p_sample.subinventory;
3619:
3620: -- Bug 4165704: changed for inventory convergence

Line 5706: FROM mtl_secondary_inventories

5702:
5703: CURSOR Cur_subinventory IS
5704: SELECT Locator_type, -- locator control
5705: description
5706: FROM mtl_secondary_inventories
5707: WHERE secondary_inventory_name = p_subinventory
5708: AND organization_id = p_organization_id;
5709:
5710: BEGIN

Line 5805: FROM mtl_secondary_inventories

5801: AND OTL.LANGUAGE = userenv('LANG');
5802:
5803: CURSOR Cur_locator_ctrl IS
5804: SELECT locator_type -- locator control
5805: FROM mtl_secondary_inventories
5806: WHERE organization_id = p_organization_id
5807: AND secondary_inventory_name = p_subinventory;
5808:
5809: