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_OP_DEST_SYS_APIS dependencies on WSH_DELIVERY_DETAILS

Line 248: wsh_delivery_details wdd,

244: mil.task_id
245: FROM
246: mtl_material_transactions_temp mmtt,
247: mtl_txn_request_lines mol,
248: wsh_delivery_details wdd,
249: wsh_delivery_assignments_v wda,
250: mtl_item_locations mil
251: WHERE
252: mmtt.transaction_temp_id = p_task_id AND

Line 271: wsh_delivery_details wdd,

267: FROM
268: mtl_material_transactions_temp mmtt,
269: mtl_material_transactions_temp pmmtt,
270: mtl_txn_request_lines mol,
271: wsh_delivery_details wdd,
272: wsh_delivery_assignments_v wda,
273: mtl_item_locations mil
274: WHERE
275: mmtt.transaction_temp_id = p_task_id AND

Line 293: FROM wsh_delivery_details wdd,

289: SELECT wdd.subinventory del_subinventory,
290: wdd.locator_id del_locator_id,
291: nvl(mil.inventory_location_type, 3) del_locator_type,
292: wdth.creation_date
293: FROM wsh_delivery_details wdd,
294: wsh_delivery_assignments_v wda,
295: mtl_item_locations mil,
296: mtl_secondary_inventories msi,
297: wms_dispatched_tasks_history wdth

Line 315: wsh_delivery_details wdd,

311: mmtt.transfer_to_location del_locator_id,
312: Nvl(mil.inventory_location_type, 3) del_locator_type,
313: Sysdate creation_date
314: FROM mtl_material_transactions_temp mmtt,
315: wsh_delivery_details wdd,
316: wsh_delivery_assignments_v wda,
317: mtl_item_locations mil,
318: mtl_secondary_inventories msi
319: WHERE mmtt.operation_plan_id = v_operation_plan_id AND

Line 341: wsh_delivery_details wdd,

337: Nvl(mil.inventory_location_type, 3) del_locator_type,
338: Sysdate creation_date
339: FROM mtl_material_transactions_temp mmtt,
340: mtl_material_transactions_temp pmmtt,
341: wsh_delivery_details wdd,
342: wsh_delivery_assignments_v wda,
343: mtl_item_locations mil,
344: mtl_secondary_inventories msi
345: WHERE mmtt.operation_plan_id = v_operation_plan_id AND

Line 371: FROM wsh_delivery_details wdd,

367: SELECT wdd.subinventory mol_subinventory,
368: wdd.locator_id mol_locator_id,
369: nvl(mil.inventory_location_type, 3) mol_locator_type,
370: wdth.creation_date
371: FROM wsh_delivery_details wdd,
372: wsh_delivery_assignments_v wda,
373: mtl_txn_request_lines mol,
374: mtl_item_locations mil,
375: mtl_secondary_inventories msi,

Line 398: wsh_delivery_details wdd,

394: Nvl(mil.inventory_location_type, 3) mol_locator_type,
395: Sysdate creation_date
396: FROM mtl_material_transactions_temp mmtt,
397: mtl_txn_request_lines mol,
398: wsh_delivery_details wdd,
399: wsh_delivery_assignments_v wda,
400: mtl_item_locations mil,
401: mtl_secondary_inventories msi
402: WHERE mmtt.operation_plan_id = v_operation_plan_id AND

Line 427: wsh_delivery_details wdd,

423: Sysdate creation_date
424: FROM mtl_material_transactions_temp mmtt,
425: mtl_material_transactions_temp pmmtt,
426: mtl_txn_request_lines mol,
427: wsh_delivery_details wdd,
428: wsh_delivery_assignments_v wda,
429: mtl_item_locations mil,
430: mtl_secondary_inventories msi
431: WHERE mmtt.operation_plan_id = v_operation_plan_id AND

Line 480: wsh_delivery_details wdd

476: AND nvl(msi.disable_date, trunc(sysdate + 1)) > trunc(sysdate)
477: -- bug 4017457
478: AND NOT exists (SELECT 1
479: FROM mtl_material_transactions_temp mmtt2,
480: wsh_delivery_details wdd
481: WHERE mmtt2.move_order_line_id = wdd.move_order_line_id AND
482: wdd.released_status = 'S' AND
483: mmtt2.transfer_organization = mil.organization_id AND
484: mmtt2.transfer_subinventory = mil.subinventory_code AND

Line 489: wsh_delivery_details wdd

485: mmtt2.transfer_to_location = mil.inventory_location_id)
486: AND NOT exists (SELECT 1
487: FROM mtl_material_transactions_temp mmtt3,
488: mtl_material_transactions_temp pmmtt2,
489: wsh_delivery_details wdd
490: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
491: wdd.released_status = 'S' AND
492: pmmtt2.transaction_temp_id = mmtt3.parent_line_id AND
493: pmmtt2.organization_id = mil.organization_id AND

Line 519: wsh_delivery_details wdd

515: AND pmmtt.transaction_temp_id = mmtt.parent_line_id
516: -- bug 4017457
517: AND NOT exists (SELECT 1
518: FROM mtl_material_transactions_temp mmtt2,
519: wsh_delivery_details wdd
520: WHERE mmtt2.move_order_line_id = wdd.move_order_line_id AND
521: wdd.released_status = 'S' AND
522: mmtt2.transfer_organization = mil.organization_id AND
523: mmtt2.transfer_subinventory = mil.subinventory_code AND

Line 528: wsh_delivery_details wdd

524: mmtt2.transfer_to_location = mil.inventory_location_id)
525: AND NOT exists (SELECT 1
526: FROM mtl_material_transactions_temp mmtt3,
527: mtl_material_transactions_temp pmmtt2,
528: wsh_delivery_details wdd
529: WHERE mmtt3.move_order_line_id = wdd.move_order_line_id AND
530: wdd.released_status = 'S' AND
531: pmmtt2.transaction_temp_id = mmtt3.parent_line_id AND
532: pmmtt2.organization_id = mil.organization_id AND

Line 1188: wsh_delivery_details wdd1,

1184: mil.organization_id
1185: FROM
1186: mtl_material_transactions_temp mmtt,
1187: mtl_txn_request_lines mol,
1188: wsh_delivery_details wdd1,
1189: wsh_delivery_details wdd2,
1190: wsh_delivery_assignments_v wda,
1191: mtl_item_locations mil
1192: WHERE

Line 1189: wsh_delivery_details wdd2,

1185: FROM
1186: mtl_material_transactions_temp mmtt,
1187: mtl_txn_request_lines mol,
1188: wsh_delivery_details wdd1,
1189: wsh_delivery_details wdd2,
1190: wsh_delivery_assignments_v wda,
1191: mtl_item_locations mil
1192: WHERE
1193: mmtt.transaction_temp_id = p_task_id AND

Line 1215: wsh_delivery_details wdd,

1211: FROM
1212: mtl_material_transactions_temp mmtt,
1213: mtl_material_transactions_temp pmmtt,
1214: mtl_txn_request_lines mol,
1215: wsh_delivery_details wdd,
1216: wsh_delivery_assignments_v wda,
1217: mtl_item_locations mil
1218: WHERE
1219: mmtt.transaction_temp_id = p_task_id AND

Line 1243: wsh_delivery_details wdd,

1239: mol.task_id,
1240: mol.organization_id
1241: FROM
1242: mtl_txn_request_lines mol,
1243: wsh_delivery_details wdd,
1244: wsh_delivery_assignments_v wda
1245: WHERE
1246: mol.line_id = p_mol_id AND
1247: wdd.move_order_line_id = mol.line_id AND

Line 1259: FROM wsh_delivery_details wdd,

1255: IS
1256: SELECT wdd.subinventory del_subinventory,
1257: wdd.locator_id del_locator_id,
1258: nvl(mil.inventory_location_type, 3) del_locator_type
1259: FROM wsh_delivery_details wdd,
1260: wsh_delivery_assignments_v wda,
1261: mtl_item_locations mil,
1262: mtl_secondary_inventories msi
1263: WHERE wda.delivery_detail_id = wdd.delivery_detail_id AND

Line 1286: FROM wsh_delivery_details wdd,

1282: IS
1283: SELECT wdd.subinventory mol_subinventory,
1284: wdd.locator_id mol_locator_id,
1285: nvl(mil.inventory_location_type, 3) mol_locator_type
1286: FROM wsh_delivery_details wdd,
1287: wsh_delivery_assignments_v wda,
1288: mtl_txn_request_lines mol,
1289: mtl_item_locations mil,
1290: mtl_secondary_inventories msi

Line 1927: wsh_delivery_details wdd,

1923: l_to_loc_id,
1924: l_organization_id,
1925: l_delivery_id
1926: FROM mtl_material_transactions_temp mmtt,
1927: wsh_delivery_details wdd,
1928: wsh_delivery_assignments_v wda
1929: WHERE mmtt.transaction_temp_id = p_task_id
1930: AND wdd.move_order_line_id = mmtt.move_order_line_id
1931: AND wdd.released_status = 'S'