APPS.WMS_UT_PKG dependencies on MTL_ITEM_LOCATIONS

Line 373: from mtl_item_locations

369: END IF;
370: l_segs := parse_text(p_loc,'.');
371: select inventory_location_id
372: into l_loc_id
373: from mtl_item_locations
374: where organization_id = p_org_id
375: and subinventory_code = p_sub_code
376: and segment1 = l_segs(1)
377: and segment2 = l_segs(2)

Line 1091: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil

1087: mr.secondary_reservation_quantity || ', ' ||
1088: mr.secondary_uom_code || ', ' ||
1089: Nvl(mr.secondary_detailed_quantity,0) as p_text
1090: INTO l_rt
1091: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
1092: WHERE reservation_id = l_new_reservation_id
1093: AND msi.organization_id = mr.organization_id
1094: AND msi.inventory_item_id = mr.inventory_item_id
1095: AND mp.organization_id = mr.organization_id

Line 2223: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil

2219: mr.secondary_reservation_quantity || ', ' ||
2220: mr.secondary_uom_code || ', ' ||
2221: Nvl(mr.secondary_detailed_quantity,0) as p_text,
2222: mr.reservation_id as reservation_id
2223: FROM mtl_reservations mr, mtl_parameters mp, mtl_system_items msi, wms_license_plate_numbers wlpn, mtl_item_locations mil
2224: WHERE
2225: Nvl(mr.supply_source_type_id, 13) = 13
2226: AND g_demand_tbl(p_di).demand_source_type_id = mr.demand_source_type_id
2227: AND nvl(g_demand_tbl(p_di).demand_source_header_id,-9999) = nvl(mr.demand_source_header_id, -9999)

Line 2281: mtl_item_locations mil

2277: SELECT DECODE(mmtt.type_code,1,'PUT :: ','PICK :: ') || mmtt.LOT_NUMBER || mmtt.FROM_SUBINVENTORY_CODE || ', ' || mil.segment1 || '.' || mil.segment2 || '.' || mil.segment3 || ', ' ||
2278: mmtt.TRANSACTION_QUANTITY || ', ' || 'UOM' || ', ' || RESERVATION_ID || ', ' || wr1.name || ', ' || wr2.name as ptext,
2279: mmtt.transaction_temp_id as transaction_temp_id
2280: FROM wms_transactions_temp mmtt, wms_rules wr1, wms_rules wr2,
2281: mtl_item_locations mil
2282: WHERE --mmtt.move_order_line_id = g_demand_tbl(p_di).mo_line_id
2283: mmtt.line_type_code = 2
2284: AND wr1.rule_id (+) = mmtt.rule_id --pick_rule_id
2285: AND wr2.rule_id (+) = mmtt.rule_id --putaway_rule_id

Line 2293: mtl_item_locations mil

2289: SELECT mmtt.TRANSACTION_TEMP_ID || ', ' || mmtt.LOT_NUMBER || mmtt.FROM_SUBINVENTORY_CODE || ', ' || mmtt.TRANSFER_SUBINVENTORY || ', ' || mil.segment1 || '.' || mil.segment2 || '.' || mil.segment3 || ', ' ||
2290: mmtt.QUANTITY || ', ' || 'UOM' || ', ' || 'RESERVATION_ID' || ', ' || wr1.name || ', ' || wr2.name as ptext,
2291: mmtt.transaction_temp_id as transaction_temp_id
2292: FROM wms_transactions_temp mmtt, wms_rules wr1, wms_rules wr2,
2293: mtl_item_locations mil
2294: WHERE --mmtt.move_order_line_id = g_demand_tbl(p_di).mo_line_id
2295: mmtt.line_type_code = 2
2296: AND wr1.rule_id (+) = mmtt.rule_id --pick_rule_id
2297: AND wr2.rule_id (+) = mmtt.rule_id --putaway_rule_id

Line 2307: mtl_item_locations mil, mtl_item_locations mil2

2303: mmtt.TRANSACTION_QUANTITY || ', ' || mmtt.TRANSACTION_UOM || ', ' || mmtt.RESERVATION_ID || ', ' || wr1.name || ', ' || wr2.name as ptext,
2304: nvl(mtlt.LOT_NUMBER,mmtt.lot_number) || ', ' || nvl(mtlt.TRANSACTION_QUANTITY,mmtt.transaction_quantity) as ltext,
2305: mmtt.transaction_temp_id as transaction_temp_id, mtlt.lot_number as lot_number
2306: FROM mtl_material_transactions_temp mmtt, wms_rules wr1, wms_rules wr2, mtl_transaction_lots_temp mtlt,
2307: mtl_item_locations mil, mtl_item_locations mil2
2308: WHERE (p_use_mol = 'Y' AND (mmtt.move_order_line_id = g_demand_tbl(p_di).mo_line_id)
2309: OR (p_use_mol = 'N' AND g_demand_tbl(p_di).demand_source_type_id = mmtt.transaction_source_type_id
2310: AND nvl(g_demand_tbl(p_di).demand_source_header_id,-9999) = nvl(mmtt.transaction_source_id, -9999)
2311: AND Nvl(g_demand_tbl(p_di).demand_source_line_id, -9999) = Nvl(mmtt.trx_source_line_id,-9999)