DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on MTL_SECONDARY_INVENTORIES

Line 4189: FROM mtl_secondary_inventories

4185: x_error_message OUT NOCOPY VARCHAR2)
4186: IS
4187: CURSOR x_sub_lov IS
4188: SELECT NVL(locator_type, 1)
4189: FROM mtl_secondary_inventories
4190: WHERE organization_id = p_organization_id
4191: AND NVL(disable_date, SYSDATE + 1) > SYSDATE
4192: AND secondary_inventory_name = p_subinventory_code
4193: AND quantity_tracked = 1;

Line 4197: FROM mtl_secondary_inventories s,

4193: AND quantity_tracked = 1;
4194:
4195: CURSOR x_sub_lov1 IS
4196: SELECT NVL(s.locator_type, 1)
4197: FROM mtl_secondary_inventories s,
4198: mtl_item_sub_inventories i
4199: WHERE s.secondary_inventory_name = i.secondary_inventory
4200: AND s.organization_id = i.organization_id
4201: AND s.organization_id = p_organization_id