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_POST_ALLOCATION dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 77: FROM mtl_material_transactions_temp mmtt

73: -- Cursor to fetch cartonization IDs for label printing
74: CURSOR c_wpr_carton_labels (p_mo_hdr_id NUMBER) IS
75: SELECT COUNT(*) l_num_rows
76: , mmtt.cartonization_id
77: FROM mtl_material_transactions_temp mmtt
78: WHERE mmtt.move_order_header_id = p_mo_hdr_id
79: AND mmtt.cartonization_id IS NOT NULL
80: GROUP BY mmtt.cartonization_id;
81:

Line 86: FROM mtl_material_transactions_temp mmtt

82: -- Cursor to fetch temp IDs for case pick labels
83: CURSOR c_wpr_casepick_labels (p_mo_hdr_id NUMBER) IS
84: -- Non-bulk tasks
85: SELECT mmtt.transaction_temp_id
86: FROM mtl_material_transactions_temp mmtt
87: WHERE mmtt.move_order_header_id = p_mo_hdr_id
88: AND mmtt.parent_line_id IS NULL
89: AND EXISTS
90: ( SELECT 'x'

Line 99: FROM mtl_material_transactions_temp mmtt

95: )
96: UNION ALL
97: -- Bulk pick parent tasks
98: SELECT mmtt.transaction_temp_id
99: FROM mtl_material_transactions_temp mmtt
100: WHERE mmtt.transaction_temp_id IN
101: ( SELECT DISTINCT mmtt2.parent_line_id
102: FROM mtl_material_transactions_temp mmtt2
103: WHERE mmtt2.move_order_header_id = p_mo_hdr_id

Line 102: FROM mtl_material_transactions_temp mmtt2

98: SELECT mmtt.transaction_temp_id
99: FROM mtl_material_transactions_temp mmtt
100: WHERE mmtt.transaction_temp_id IN
101: ( SELECT DISTINCT mmtt2.parent_line_id
102: FROM mtl_material_transactions_temp mmtt2
103: WHERE mmtt2.move_order_header_id = p_mo_hdr_id
104: AND mmtt2.parent_line_id IS NOT NULL
105: AND mmtt2.transaction_temp_id <> mmtt2.parent_line_id
106: )

Line 119: FROM mtl_material_transactions_temp mmtt

115: -- Op plan assignment: fetch unique item IDs across all records
116: CURSOR c_wpr_opa (p_mo_hdr_id NUMBER) IS
117: SELECT COUNT(*) l_num_rows
118: , mmtt.inventory_item_id
119: FROM mtl_material_transactions_temp mmtt
120: WHERE mmtt.move_order_header_id = p_mo_hdr_id
121: GROUP BY mmtt.inventory_item_id;
122:
123: -- Task type assignment: fetch unique item IDs from

Line 128: FROM mtl_material_transactions_temp mmtt

124: -- bulk pick parent tasks and non-bulk tasks
125: CURSOR c_wpr_tta (p_mo_hdr_id NUMBER) IS
126: SELECT COUNT(*) l_num_rows
127: , mmtt.inventory_item_id
128: FROM mtl_material_transactions_temp mmtt
129: WHERE ( mmtt.move_order_header_id = p_mo_hdr_id
130: AND mmtt.parent_line_id IS NULL)
131: OR ( mmtt.transaction_temp_id IN
132: ( SELECT DISTINCT mmtt2.parent_line_id

Line 133: FROM mtl_material_transactions_temp mmtt2

129: WHERE ( mmtt.move_order_header_id = p_mo_hdr_id
130: AND mmtt.parent_line_id IS NULL)
131: OR ( mmtt.transaction_temp_id IN
132: ( SELECT DISTINCT mmtt2.parent_line_id
133: FROM mtl_material_transactions_temp mmtt2
134: WHERE mmtt2.move_order_header_id = p_mo_hdr_id
135: AND mmtt2.parent_line_id IS NOT NULL
136: AND mmtt2.transaction_temp_id <> mmtt2.parent_line_id
137: )

Line 229: UPDATE mtl_material_transactions_temp mmtt

225:
226: l_num_sub_batches := l_num_sub_batches + 1;
227:
228: FORALL ii IN l_tmp_ids.FIRST..l_tmp_ids.LAST
229: UPDATE mtl_material_transactions_temp mmtt
230: SET mmtt.transaction_batch_id = l_sub_batch_id
231: WHERE mmtt.transaction_temp_id = l_tmp_ids(ii);
232:
233: END LOOP; --}

Line 284: UPDATE mtl_material_transactions_temp mmtt

280:
281: l_num_sub_batches := l_num_sub_batches + l_itm_ids.COUNT;
282:
283: FORALL jj IN l_sub_ids.FIRST..l_sub_ids.LAST
284: UPDATE mtl_material_transactions_temp mmtt
285: SET mmtt.transaction_batch_id = l_sub_ids(jj)
286: WHERE mmtt.inventory_item_id = l_itm_ids(jj)
287: AND ( ( mmtt.move_order_header_id = p_mo_header_id
288: AND mmtt.parent_line_id IS NULL)

Line 292: FROM mtl_material_transactions_temp mmtt2

288: AND mmtt.parent_line_id IS NULL)
289: OR ( p_mode = 'TTA'
290: AND mmtt.transaction_temp_id IN
291: ( SELECT DISTINCT mmtt2.parent_line_id
292: FROM mtl_material_transactions_temp mmtt2
293: WHERE mmtt2.move_order_header_id = p_mo_header_id
294: AND mmtt2.parent_line_id IS NOT NULL
295: AND mmtt2.transaction_temp_id <> mmtt2.parent_line_id
296: )

Line 610: UPDATE mtl_material_transactions_temp

606: IF g_debug = 1 THEN
607: print_debug ('l_op_plan_id value: ' || l_op_plan_id, l_api_name);
608: END IF;
609:
610: UPDATE mtl_material_transactions_temp
611: SET operation_plan_id = l_op_plan_id
612: WHERE move_order_header_id = p_mo_header_id;
613: END IF;
614:

Line 782: UPDATE mtl_material_transactions_temp

778: IF g_debug = 1 THEN
779: print_debug ('l_ttype_id value: ' || l_ttype_id, l_api_name);
780: END IF;
781:
782: UPDATE mtl_material_transactions_temp
783: SET standard_operation_id = l_ttype_id
784: WHERE move_order_header_id = p_mo_header_id;
785: END IF;
786:

Line 845: FROM mtl_material_transactions_temp mmtt1

841: CURSOR c_lbl_data_exists IS
842: SELECT 'x' FROM dual
843: WHERE EXISTS
844: ( SELECT 'x'
845: FROM mtl_material_transactions_temp mmtt1
846: WHERE mmtt1.move_order_header_id = p_mo_header_id
847: AND mmtt1.cartonization_id IS NOT NULL
848: )
849: OR EXISTS

Line 851: FROM mtl_material_transactions_temp mmtt2

847: AND mmtt1.cartonization_id IS NOT NULL
848: )
849: OR EXISTS
850: ( SELECT 'x'
851: FROM mtl_material_transactions_temp mmtt2
852: WHERE mmtt2.move_order_header_id = p_mo_header_id
853: AND EXISTS
854: ( SELECT 'x'
855: FROM wms_user_task_type_attributes wutta1

Line 863: FROM mtl_material_transactions_temp mmtt3

859: )
860: )
861: OR EXISTS
862: ( SELECT 'x'
863: FROM mtl_material_transactions_temp mmtt3
864: WHERE mmtt3.transaction_temp_id IN
865: ( SELECT DISTINCT mmtt4.parent_line_id
866: FROM mtl_material_transactions_temp mmtt4
867: WHERE mmtt4.move_order_header_id = p_mo_header_id

Line 866: FROM mtl_material_transactions_temp mmtt4

862: ( SELECT 'x'
863: FROM mtl_material_transactions_temp mmtt3
864: WHERE mmtt3.transaction_temp_id IN
865: ( SELECT DISTINCT mmtt4.parent_line_id
866: FROM mtl_material_transactions_temp mmtt4
867: WHERE mmtt4.move_order_header_id = p_mo_header_id
868: AND mmtt4.parent_line_id IS NOT NULL
869: AND mmtt4.transaction_temp_id <> mmtt4.parent_line_id
870: )

Line 1117: UPDATE mtl_material_transactions_temp

1113: 'p_mo_header_id => ' || TO_CHAR(p_mo_header_id)
1114: , l_api_name);
1115: END IF;
1116:
1117: UPDATE mtl_material_transactions_temp
1118: SET transaction_batch_id = NULL
1119: , lock_flag = NULL -- newly added
1120: WHERE move_order_header_id = p_mo_header_id;
1121:

Line 1123: UPDATE mtl_material_transactions_temp

1119: , lock_flag = NULL -- newly added
1120: WHERE move_order_header_id = p_mo_header_id;
1121:
1122: IF g_consolidate_tasks THEN
1123: UPDATE mtl_material_transactions_temp
1124: SET transaction_batch_id = NULL,
1125: lock_flag = NULL -- bug 9130704
1126: WHERE transaction_temp_id IN
1127: ( SELECT DISTINCT mmtt2.parent_line_id

Line 1128: FROM mtl_material_transactions_temp mmtt2

1124: SET transaction_batch_id = NULL,
1125: lock_flag = NULL -- bug 9130704
1126: WHERE transaction_temp_id IN
1127: ( SELECT DISTINCT mmtt2.parent_line_id
1128: FROM mtl_material_transactions_temp mmtt2
1129: WHERE move_order_header_id = p_mo_header_id
1130: AND parent_line_id IS NOT NULL
1131: );
1132: END IF;

Line 1168: UPDATE mtl_material_transactions_temp

1164: 'p_mo_header_id => ' || TO_CHAR(p_mo_header_id)
1165: , l_api_name);
1166: END IF;
1167:
1168: UPDATE mtl_material_transactions_temp
1169: SET wms_task_status = 1
1170: WHERE move_order_header_id = p_mo_header_id;
1171:
1172: IF g_consolidate_tasks THEN

Line 1173: UPDATE mtl_material_transactions_temp

1169: SET wms_task_status = 1
1170: WHERE move_order_header_id = p_mo_header_id;
1171:
1172: IF g_consolidate_tasks THEN
1173: UPDATE mtl_material_transactions_temp
1174: SET wms_task_status = 1
1175: WHERE transaction_temp_id IN
1176: ( SELECT DISTINCT mmtt2.parent_line_id
1177: FROM mtl_material_transactions_temp mmtt2

Line 1177: FROM mtl_material_transactions_temp mmtt2

1173: UPDATE mtl_material_transactions_temp
1174: SET wms_task_status = 1
1175: WHERE transaction_temp_id IN
1176: ( SELECT DISTINCT mmtt2.parent_line_id
1177: FROM mtl_material_transactions_temp mmtt2
1178: WHERE move_order_header_id = p_mo_header_id
1179: AND parent_line_id IS NOT NULL
1180: );
1181: END IF;

Line 1676: FROM mtl_material_transactions_temp mmtt

1672: SELECT mmtt.transaction_temp_id
1673: , mmtt.parent_line_id
1674: , msi.lot_control_code
1675: , msi.serial_number_control_code
1676: FROM mtl_material_transactions_temp mmtt
1677: , mtl_system_items msi
1678: WHERE mmtt.move_order_header_id = p_mo_header_id
1679: AND mmtt.parent_line_id IS NOT NULL
1680: AND msi.inventory_item_id = mmtt.inventory_item_id

Line 1841: FROM mtl_material_transactions_temp

1837: SELECT 'x' INTO l_dummy
1838: FROM dual
1839: WHERE EXISTS
1840: ( SELECT 'x'
1841: FROM mtl_material_transactions_temp
1842: WHERE move_order_header_id = l_mo_header_id
1843: AND wms_task_status = 8 -- Unreleased
1844: );
1845: IF g_debug = 1 THEN

Line 1876: FROM mtl_material_transactions_temp

1872: SELECT 'x' INTO l_dummy
1873: FROM dual
1874: WHERE EXISTS
1875: ( SELECT 'x'
1876: FROM mtl_material_transactions_temp
1877: WHERE move_order_header_id = l_mo_header_id
1878: AND wms_task_status = 1 -- Released
1879: );
1880: IF g_debug = 1 THEN

Line 1911: ( SELECT 'x' FROM mtl_material_transactions_temp

1907: l_bulk_tasks_exist := FALSE;
1908: BEGIN
1909: SELECT 'x' INTO l_dummy FROM dual
1910: WHERE EXISTS
1911: ( SELECT 'x' FROM mtl_material_transactions_temp
1912: WHERE move_order_header_id = l_mo_header_id
1913: AND parent_line_id IS NOT NULL
1914: );
1915: l_bulk_tasks_exist := TRUE;

Line 1941: UPDATE mtl_material_transactions_temp

1937:
1938: EXIT WHEN l_child_task_id.COUNT = 0;
1939:
1940: FORALL ll IN l_child_task_id.FIRST .. l_child_task_id.LAST
1941: UPDATE mtl_material_transactions_temp
1942: SET parent_line_id = NULL
1943: WHERE transaction_temp_id = l_child_task_id(ll);
1944:
1945: FOR ii IN l_child_task_id.FIRST .. l_child_task_id.LAST LOOP --{

Line 1979: UPDATE mtl_material_transactions_temp

1975: -- If first time, and cartonization is turned on,
1976: -- delete pre-existing cartonization suggestions
1977: --
1978: IF l_mode IS NULL AND g_call_cartonization THEN --{
1979: UPDATE mtl_material_transactions_temp
1980: SET cartonization_id = NULL
1981: , container_item_id = NULL
1982: WHERE move_order_header_id = l_mo_header_id
1983: AND cartonization_id IS NOT NULL;