APPS.WMS_RULE_EXTN_PVT dependencies on WMS_TRANSACTIONS_TEMP

Line 307: FROM wms_transactions_temp

303: , sum(primary_quantity) primary_quantity
304: , sum(transaction_quantity) transaction_quantity
305: , sum(secondary_quantity) secondary_quantity
306: , revision || ' - ' || lot_number || ' - ' || from_subinventory_code || ' - ' || from_locator_id || ' - ' || lpn_id as sugg_str
307: FROM wms_transactions_temp
308: WHERE line_type_code = 2
309: GROUP BY from_organization_id,
310: lot_number, from_subinventory_code, revision,
311: from_locator_id, lpn_id, reservation_id

Line 322: FROM wms_transactions_temp

318: , lc_lot_num VARCHAR2
319: , lc_lpn_id NUMBER
320: , lc_res_id NUMBER) IS
321: SELECT serial_number
322: FROM wms_transactions_temp
323: WHERE line_type_code = 2
324: AND from_organization_id = lc_from_org
325: AND from_subinventory_code = lc_from_sub
326: AND nvl(from_locator_id,-888) = nvl(lc_from_loc,-888)

Line 352: FROM wms_transactions_temp

348: , to_cost_group_id
349: , sum(primary_quantity) primary_quantity
350: , sum(transaction_quantity) transaction_quantity
351: , sum(secondary_quantity) secondary_quantity
352: FROM wms_transactions_temp
353: WHERE line_type_code = 2
354: GROUP BY from_organization_id, to_organization_id, revision,
355: lot_number, lot_expiration_date, from_subinventory_code,
356: to_subinventory_code, from_locator_id, to_locator_id, lpn_id, reservation_id,

Line 442: DELETE FROM WMS_TRANSACTIONS_TEMP WHERE line_type_code = 2;

438: l_rsv_index(l_demand_rsvs_ordered(i).reservation_id) := i;
439: END LOOP;
440: END IF;
441:
442: DELETE FROM WMS_TRANSACTIONS_TEMP WHERE line_type_code = 2;
443:
444: /* Call create suggestions */
445: wms_engine_pvt.create_suggestions(
446: p_api_version => 1.0