APPS.WMS_RULE_EXTN_PVT dependencies on WMS_TRANSACTIONS_TEMP

Line 324: FROM wms_transactions_temp

320: , sum(primary_quantity) primary_quantity
321: , sum(transaction_quantity) transaction_quantity
322: , sum(secondary_quantity) secondary_quantity
323: , revision || ' - ' || lot_number || ' - ' || from_subinventory_code || ' - ' || from_locator_id || ' - ' || lpn_id as sugg_str
324: FROM wms_transactions_temp
325: WHERE line_type_code = 2
326: GROUP BY from_organization_id,
327: lot_number, from_subinventory_code, revision,
328: from_locator_id, lpn_id, reservation_id

Line 358: FROM wms_transactions_temp

354: , lc_lot_num VARCHAR2
355: , lc_lpn_id NUMBER
356: , lc_res_id NUMBER) IS
357: SELECT serial_number
358: FROM wms_transactions_temp
359: WHERE line_type_code = 2
360: AND from_organization_id = lc_from_org
361: AND from_subinventory_code = lc_from_sub
362: AND nvl(from_locator_id,-888) = nvl(lc_from_loc,-888)

Line 388: FROM wms_transactions_temp

384: , to_cost_group_id
385: , sum(primary_quantity) primary_quantity
386: , sum(transaction_quantity) transaction_quantity
387: , sum(secondary_quantity) secondary_quantity
388: FROM wms_transactions_temp
389: WHERE line_type_code = 2
390: GROUP BY from_organization_id, to_organization_id, revision,
391: lot_number, lot_expiration_date, from_subinventory_code,
392: to_subinventory_code, from_locator_id, to_locator_id, lpn_id, reservation_id,

Line 578: DELETE FROM WMS_TRANSACTIONS_TEMP WHERE line_type_code = 2;

574:
575: p_mo_line_rec := inv_trolin_util.query_row(p_mo_line_rec.line_id);
576: -- bug 12314831 end
577:
578: DELETE FROM WMS_TRANSACTIONS_TEMP WHERE line_type_code = 2;
579:
580: /* Call create suggestions */
581: wms_engine_pvt.create_suggestions(
582: p_api_version => 1.0