APPS.WMS_UT_PKG dependencies on WMS_TRANSACTIONS_TEMP

Line 2147: delete wms_transactions_temp;

2143:
2144: print_debug ('Mo Line ID : ' || g_trolin_tbl(i).line_id);
2145: select sysdate into l_start from dual;
2146:
2147: delete wms_transactions_temp;
2148:
2149: l_demand_info.oe_line_id := g_trolin_tbl(i).line_id;
2150:
2151: l_dem_indx := g_link_mo_dem(g_trolin_tbl(i).line_id);

Line 2280: FROM wms_transactions_temp mmtt, wms_rules wr1, wms_rules wr2,

2276: CURSOR c_get_wtt_lines (p_di NUMBER) IS
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

Line 2292: FROM wms_transactions_temp mmtt, wms_rules wr1, wms_rules wr2,

2288: /*CURSOR c_get_wtt_lines (p_di NUMBER) IS
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