APPS.INV_MWB_TREE1 dependencies on MTL_SECONDARY_INVENTORIES

Line 7442: query_str := query_str || 'FROM wms_license_plate_numbers wlpn, mtl_secondary_inventories msi WHERE 1=1 and msi.secondary_inventory_name = wlpn.subinventory_code and wlpn.organization_id = msi.organization_id ';

7438: --ER(3338592) Changes
7439: AND inv_mwb_globals.g_item_description IS NULL THEN
7440: --End of ER Changes
7441: query_str := 'select wlpn.subinventory_code ';
7442: query_str := query_str || 'FROM wms_license_plate_numbers wlpn, mtl_secondary_inventories msi WHERE 1=1 and msi.secondary_inventory_name = wlpn.subinventory_code and wlpn.organization_id = msi.organization_id ';
7443:
7444: -- query_str := query_str || 'AND (lpn_context = 1 or lpn_context=11 ');
7445:
7446: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

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

7492:
7493: query_str := query_str || ' GROUP BY subinventory_code ';
7494: query_str := query_str || ' ORDER BY subinventory_code ';
7495: ELSE
7496: query_str := 'SELECT msi.secondary_inventory_name subinventory_code FROM mtl_secondary_inventories msi ';
7497: query_str := query_str || ' WHERE msi.secondary_inventory_name in ( ';
7498:
7499: -- Need to use MTL_ONHAND_TOTAL_V
7500: IF (

Line 9008: FROM mtl_secondary_inventories

9004: AND (inv_mwb_globals.g_subinventory_code IS NOT NULL
9005: OR inv_mwb_globals.g_tree_subinventory_code IS NOT NULL) THEN
9006: SELECT locator_type
9007: INTO loc_type
9008: FROM mtl_secondary_inventories
9009: WHERE secondary_inventory_name = NVL(inv_mwb_globals.g_tree_subinventory_code,
9010: inv_mwb_globals.g_subinventory_code)
9011: AND organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
9012: inv_mwb_globals.g_organization_id);