DBA Data[Home] [Help]

APPS.GME_MOBILE_LOVS dependencies on MTL_ITEM_SUB_INVENTORIES

Line 2244: mtl_item_sub_inventories i

2240: SELECT s.secondary_inventory_name
2241: , s.description
2242: , NVL(s.locator_type, 1)
2243: FROM mtl_secondary_inventories s,
2244: mtl_item_sub_inventories i
2245: WHERE s.secondary_inventory_name = i.secondary_inventory
2246: AND s.organization_id = i.organization_id
2247: AND s.organization_id = p_organization_id
2248: AND i.inventory_item_id = p_item_id