DBA Data[Home] [Help]

APPS.INV_MWB_TREE dependencies on MTL_SECONDARY_INVENTORIES

Line 2760: query_str := 'SELECT msi.secondary_inventory_name subinventory_code FROM mtl_secondary_inventories msi ';

2756:
2757: query_str := query_str || ' GROUP BY subinventory_code ';
2758: query_str := query_str || ' ORDER BY subinventory_code ';
2759: ELSE
2760: query_str := 'SELECT msi.secondary_inventory_name subinventory_code FROM mtl_secondary_inventories msi ';
2761: query_str := query_str || ' WHERE msi.secondary_inventory_name in ( ';
2762:
2763: -- Need to use MTL_ONHAND_TOTAL_V
2764: IF (

Line 3724: FROM mtl_secondary_inventories

3720: IF p_organization_id IS NOT NULL
3721: AND p_subinventory_code IS NOT NULL THEN
3722: SELECT locator_type
3723: INTO loc_type
3724: FROM mtl_secondary_inventories
3725: WHERE secondary_inventory_name = p_subinventory_code
3726: AND organization_id = p_organization_id;
3727:
3728: IF loc_type = 1 THEN