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_CARTNZN_PUB dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 413: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

409: --Bug3628747
410: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
411: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
412: AND Exists ( select 1
413: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
414: Where wdd.move_order_line_id = mmtt.move_order_line_id
415: AND wdd.delivery_detail_id = wda.delivery_Detail_id
416: AND nvl(wda.delivery_id,-1) = decode(p_input_for_bulk.delivery_id,null,nvl(wda.delivery_id,-1),p_input_for_bulk.delivery_id)
417: )

Line 435: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

431: AND mmtt.move_order_header_id = mag.move_order_header_id
432: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
433: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
434: AND Exists ( select 1
435: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
436: Where wdd.move_order_line_id = mmtt.move_order_line_id
437: AND wdd.delivery_detail_id = wda.delivery_Detail_id
438: AND nvl(wda.delivery_id,-1) = decode(p_input_for_bulk.delivery_id,null,nvl(wda.delivery_id,-1),p_input_for_bulk.delivery_id)
439: )

Line 476: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

472: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
473: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
474: nvl(p_input_for_bulk.end_release_date,moh.creation_date)
475: AND Exists ( select 1
476: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
477: Where wdd.move_order_line_id = mmtt.move_order_line_id
478: AND wdd.delivery_detail_id = wda.delivery_Detail_id
479: AND nvl(wda.delivery_id,-1) = decode(p_input_for_bulk.delivery_id,null,nvl(wda.delivery_id,-1),p_input_for_bulk.delivery_id)
480: )

Line 507: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

503: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
504: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
505: nvl(p_input_for_bulk.end_release_date,moh.creation_date)
506: AND Exists ( select 1
507: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
508: Where wdd.move_order_line_id = mmtt.move_order_line_id
509: AND wdd.delivery_detail_id = wda.delivery_Detail_id
510: AND nvl(wda.delivery_id,-1) = decode(p_input_for_bulk.delivery_id,null,nvl(wda.delivery_id,-1),p_input_for_bulk.delivery_id)
511: )

Line 526: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,

522: for update of mmtt.transaction_temp_id; -- to lock the records
523:
524: CURSOR c11_bulk_trip(p_organization_id NUMBER) IS
525: select mmtt.*
526: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
527: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
528: wsh_pick_grouping_rules spg
529: where wts.trip_id = p_input_for_bulk.trip_id
530: and wdl.pick_up_stop_id = wts.stop_id

Line 554: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

550: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
551: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
552: nvl(p_input_for_bulk.end_release_date,moh.creation_date)
553: AND Exists ( select 1
554: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
555: Where wdd.move_order_line_id = mmtt.move_order_line_id
556: AND wdd.delivery_detail_id = wda.delivery_Detail_id
557: AND nvl(wda.delivery_id,-1) = decode(p_input_for_bulk.delivery_id,null,nvl(wda.delivery_id,-1),p_input_for_bulk.delivery_id)
558: )

Line 563: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,

559: for update of mmtt.transaction_temp_id; -- to lock the records
560:
561: CURSOR c11_bulk_trip_sub_item(p_organization_id NUMBER) IS
562: select mmtt.*
563: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
564: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
565: wsh_pick_grouping_rules spg
566: where wts.trip_id = p_input_for_bulk.trip_id
567: and wdl.pick_up_stop_id = wts.stop_id

Line 591: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

587: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
588: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
589: nvl(p_input_for_bulk.end_release_date,moh.creation_date)
590: AND Exists ( select 1
591: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
592: Where wdd.move_order_line_id = mmtt.move_order_line_id
593: AND wdd.delivery_detail_id = wda.delivery_Detail_id
594: AND nvl(wda.delivery_id,-1) = decode(p_input_for_bulk.delivery_id,null,nvl(wda.delivery_id,-1),p_input_for_bulk.delivery_id)
595: )

Line 7813: wsh_delivery_assignments wda

7809: SELECT DISTINCT wda.delivery_id
7810: FROM mtl_txn_request_lines mtrl,
7811: wms_cartonization_temp wct,
7812: wsh_delivery_details wdd ,
7813: wsh_delivery_assignments wda
7814: WHERE mtrl.organization_id = p_org_id
7815: AND mtrl.header_id = p_move_order_header_id
7816: AND wct.move_order_line_id = mtrl.line_id
7817: AND wct.organization_id = mtrl.organization_id

Line 7832: wsh_delivery_assignments wda

7828: SELECT DISTINCT wda.delivery_id
7829: FROM mtl_txn_request_lines mtrl,
7830: wms_cartonization_temp wct,
7831: wsh_delivery_details wdd ,
7832: wsh_delivery_assignments wda
7833: WHERE mtrl.organization_id = p_org_id
7834: AND mtrl.header_id = p_move_order_header_id
7835: AND wct.move_order_line_id = mtrl.line_id
7836: AND wct.organization_id = mtrl.organization_id

Line 7927: wsh_delivery_assignments wda,

7923: WHERE transaction_temp_id IN
7924: (SELECT wct.transaction_temp_id
7925: FROM wsh_delivery_details wdd ,
7926: wms_cartonization_temp wct ,
7927: wsh_delivery_assignments wda,
7928: mtl_txn_request_lines mtrl
7929: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
7930: AND wdd.source_line_id = wct.demand_source_line
7931: AND wct.move_order_line_id = mtrl.line_id

Line 7962: wsh_delivery_assignments wda

7958: INTO l_del_det_id_tab
7959: FROM mtl_txn_request_lines mtrl,
7960: wms_cartonization_temp wct,
7961: wsh_delivery_details wdd ,
7962: wsh_delivery_assignments wda
7963: WHERE mtrl.organization_id = p_org_id
7964: AND mtrl.header_id = p_move_order_header_id
7965: AND wct.move_order_line_id = mtrl.line_id
7966: AND wct.organization_id = mtrl.organization_id

Line 7979: wsh_delivery_assignments wda

7975: INTO l_del_det_id_tab
7976: FROM mtl_txn_request_lines mtrl,
7977: wms_cartonization_temp wct,
7978: wsh_delivery_details wdd ,
7979: wsh_delivery_assignments wda
7980: WHERE mtrl.organization_id = p_org_id
7981: AND mtrl.header_id = p_move_order_header_id
7982: AND wct.move_order_line_id = mtrl.line_id
7983: AND wct.organization_id = mtrl.organization_id

Line 8115: wsh_delivery_assignments wda

8111: SELECT DISTINCT wda.delivery_id
8112: FROM mtl_txn_request_lines mtrl,
8113: wms_cartonization_temp wct,
8114: wsh_delivery_details wdd ,
8115: wsh_delivery_assignments wda
8116: WHERE mtrl.organization_id = p_org_id
8117: AND mtrl.header_id = p_move_order_header_id
8118: AND wct.move_order_line_id = mtrl.line_id
8119: AND wct.organization_id = mtrl.organization_id

Line 8134: wsh_delivery_assignments wda

8130: SELECT DISTINCT wda.delivery_id
8131: FROM mtl_txn_request_lines mtrl,
8132: wms_cartonization_temp wct,
8133: wsh_delivery_details wdd ,
8134: wsh_delivery_assignments wda
8135: WHERE mtrl.organization_id = p_org_id
8136: AND mtrl.header_id = p_move_order_header_id
8137: AND wct.move_order_line_id = mtrl.line_id
8138: AND wct.organization_id = mtrl.organization_id