DBA Data[Home] [Help]

APPS.GME_MOBILE_TXN dependencies on MTL_SECONDARY_INVENTORIES

Line 4319: FROM mtl_secondary_inventories

4315: x_error_message OUT NOCOPY VARCHAR2)
4316: IS
4317: CURSOR x_sub_lov IS
4318: SELECT NVL(locator_type, 1)
4319: FROM mtl_secondary_inventories
4320: WHERE organization_id = p_organization_id
4321: AND NVL(disable_date, SYSDATE + 1) > SYSDATE
4322: AND secondary_inventory_name = p_subinventory_code
4323: AND quantity_tracked = 1;

Line 4327: FROM mtl_secondary_inventories s,

4323: AND quantity_tracked = 1;
4324:
4325: CURSOR x_sub_lov1 IS
4326: SELECT NVL(s.locator_type, 1)
4327: FROM mtl_secondary_inventories s,
4328: mtl_item_sub_inventories i
4329: WHERE s.secondary_inventory_name = i.secondary_inventory
4330: AND s.organization_id = i.organization_id
4331: AND s.organization_id = p_organization_id