eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_UT_PKG dependencies on WMS_RULES

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

Line 2306: FROM mtl_material_transactions_temp mmtt, wms_rules wr1, wms_rules wr2, mtl_transaction_lots_temp mtlt,

2302: mil.segment1 || '.' || mil.segment2 || '.' || mil.segment3 || ', ' || mil2.segment1 || '.' || mil2.segment2 || '.' || mil2.segment3 || ', ' ||
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)