APPS.INV_MWB_TREE1 dependencies on MTL_SECONDARY_INVENTORIES

Line 6250: 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 ';

6246: --ER(3338592) Changes
6247: AND inv_mwb_globals.g_item_description IS NULL THEN
6248: --End of ER Changes
6249: query_str := 'select wlpn.subinventory_code ';
6250: 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 ';
6251:
6252: -- query_str := query_str || 'AND (lpn_context = 1 or lpn_context=11 ');
6253:
6254: IF inv_mwb_globals.g_tree_mat_loc_id = 2 THEN

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

6300:
6301: query_str := query_str || ' GROUP BY subinventory_code ';
6302: query_str := query_str || ' ORDER BY subinventory_code ';
6303: ELSE
6304: query_str := 'SELECT msi.secondary_inventory_name subinventory_code FROM mtl_secondary_inventories msi ';
6305: query_str := query_str || ' WHERE msi.secondary_inventory_name in ( ';
6306:
6307: -- Need to use MTL_ONHAND_TOTAL_V
6308: IF (

Line 7573: FROM mtl_secondary_inventories

7569: AND (inv_mwb_globals.g_subinventory_code IS NOT NULL
7570: OR inv_mwb_globals.g_tree_subinventory_code IS NOT NULL) THEN
7571: SELECT locator_type
7572: INTO loc_type
7573: FROM mtl_secondary_inventories
7574: WHERE secondary_inventory_name = NVL(inv_mwb_globals.g_tree_subinventory_code,
7575: inv_mwb_globals.g_subinventory_code)
7576: AND organization_id = NVL(inv_mwb_globals.g_tree_organization_id,
7577: inv_mwb_globals.g_organization_id);