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 513: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

509: --Bug3628747
510: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
511: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
512: AND Exists ( select 1
513: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
514: Where wdd.move_order_line_id = mmtt.move_order_line_id
515: AND wdd.delivery_detail_id = wda.delivery_Detail_id
516: 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)
517: )

Line 534: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

530: AND mmtt.move_order_header_id = mag.move_order_header_id
531: AND mmtt.subinventory_code = nvl(p_input_for_bulk.subinventory_code, mmtt.subinventory_code)
532: AND mmtt.inventory_item_id = nvl(p_input_for_bulk.item_id,mmtt.inventory_item_id)
533: AND Exists ( select 1
534: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
535: Where wdd.move_order_line_id = mmtt.move_order_line_id
536: AND wdd.delivery_detail_id = wda.delivery_Detail_id
537: 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)
538: )

Line 574: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

570: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
571: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
572: nvl(p_input_for_bulk.end_release_date,moh.creation_date)
573: AND Exists ( select 1
574: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
575: Where wdd.move_order_line_id = mmtt.move_order_line_id
576: AND wdd.delivery_detail_id = wda.delivery_Detail_id
577: 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)
578: )

Line 604: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

600: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
601: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
602: nvl(p_input_for_bulk.end_release_date,moh.creation_date)
603: AND Exists ( select 1
604: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
605: Where wdd.move_order_line_id = mmtt.move_order_line_id
606: AND wdd.delivery_detail_id = wda.delivery_Detail_id
607: 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)
608: )

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

619: for update of mmtt.transaction_temp_id; -- to lock the records
620:
621: CURSOR c11_bulk_trip(p_organization_id NUMBER) IS
622: select mmtt.*
623: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
624: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
625: wsh_pick_grouping_rules spg
626: where wts.trip_id = p_input_for_bulk.trip_id
627: and wdl.pick_up_stop_id = wts.stop_id

Line 650: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

646: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
647: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
648: nvl(p_input_for_bulk.end_release_date,moh.creation_date)
649: AND Exists ( select 1
650: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
651: Where wdd.move_order_line_id = mmtt.move_order_line_id
652: AND wdd.delivery_detail_id = wda.delivery_Detail_id
653: 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)
654: )

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

655: for update of mmtt.transaction_temp_id; -- to lock the records
656:
657: CURSOR c11_bulk_trip_sub_item(p_organization_id NUMBER) IS
658: select mmtt.*
659: from wsh_delivery_legs wdl,wsh_delivery_details wdd, wsh_delivery_assignments_v wda,
660: wsh_trip_stops wts, mtl_material_transactions_temp mmtt,mtl_txn_request_headers moh,
661: wsh_pick_grouping_rules spg
662: where wts.trip_id = p_input_for_bulk.trip_id
663: and wdl.pick_up_stop_id = wts.stop_id

Line 686: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda

682: nvl(p_input_for_bulk.end_mo_request_number,moh.request_number)
683: AND moh.creation_date between nvl(p_input_for_bulk.start_release_date,moh.creation_date) and
684: nvl(p_input_for_bulk.end_release_date,moh.creation_date)
685: AND Exists ( select 1
686: From wsh_delivery_details wdd,wsh_delivery_assignments_v wda
687: Where wdd.move_order_line_id = mmtt.move_order_line_id
688: AND wdd.delivery_detail_id = wda.delivery_Detail_id
689: 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)
690: )

Line 7724: wsh_delivery_assignments wda

7720: SELECT DISTINCT wda.delivery_id
7721: FROM mtl_txn_request_lines mtrl,
7722: wms_cartonization_temp wct,
7723: wsh_delivery_details wdd ,
7724: wsh_delivery_assignments wda
7725: WHERE mtrl.organization_id = p_org_id
7726: AND mtrl.header_id = p_move_order_header_id
7727: AND wct.move_order_line_id = mtrl.line_id
7728: AND wct.organization_id = mtrl.organization_id

Line 7743: wsh_delivery_assignments wda

7739: SELECT DISTINCT wda.delivery_id
7740: FROM mtl_txn_request_lines mtrl,
7741: wms_cartonization_temp wct,
7742: wsh_delivery_details wdd ,
7743: wsh_delivery_assignments wda
7744: WHERE mtrl.organization_id = p_org_id
7745: AND mtrl.header_id = p_move_order_header_id
7746: AND wct.move_order_line_id = mtrl.line_id
7747: AND wct.organization_id = mtrl.organization_id

Line 7838: wsh_delivery_assignments wda,

7834: WHERE transaction_temp_id IN
7835: (SELECT wct.transaction_temp_id
7836: FROM wsh_delivery_details wdd ,
7837: wms_cartonization_temp wct ,
7838: wsh_delivery_assignments wda,
7839: mtl_txn_request_lines mtrl
7840: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
7841: AND wdd.source_line_id = wct.demand_source_line
7842: AND wct.move_order_line_id = mtrl.line_id

Line 7873: wsh_delivery_assignments wda

7869: INTO l_del_det_id_tab
7870: FROM mtl_txn_request_lines mtrl,
7871: wms_cartonization_temp wct,
7872: wsh_delivery_details wdd ,
7873: wsh_delivery_assignments wda
7874: WHERE mtrl.organization_id = p_org_id
7875: AND mtrl.header_id = p_move_order_header_id
7876: AND wct.move_order_line_id = mtrl.line_id
7877: AND wct.organization_id = mtrl.organization_id

Line 7890: wsh_delivery_assignments wda

7886: INTO l_del_det_id_tab
7887: FROM mtl_txn_request_lines mtrl,
7888: wms_cartonization_temp wct,
7889: wsh_delivery_details wdd ,
7890: wsh_delivery_assignments wda
7891: WHERE mtrl.organization_id = p_org_id
7892: AND mtrl.header_id = p_move_order_header_id
7893: AND wct.move_order_line_id = mtrl.line_id
7894: AND wct.organization_id = mtrl.organization_id

Line 8026: wsh_delivery_assignments wda

8022: SELECT DISTINCT wda.delivery_id
8023: FROM mtl_txn_request_lines mtrl,
8024: wms_cartonization_temp wct,
8025: wsh_delivery_details wdd ,
8026: wsh_delivery_assignments wda
8027: WHERE mtrl.organization_id = p_org_id
8028: AND mtrl.header_id = p_move_order_header_id
8029: AND wct.move_order_line_id = mtrl.line_id
8030: AND wct.organization_id = mtrl.organization_id

Line 8045: wsh_delivery_assignments wda

8041: SELECT DISTINCT wda.delivery_id
8042: FROM mtl_txn_request_lines mtrl,
8043: wms_cartonization_temp wct,
8044: wsh_delivery_details wdd ,
8045: wsh_delivery_assignments wda
8046: WHERE mtrl.organization_id = p_org_id
8047: AND mtrl.header_id = p_move_order_header_id
8048: AND wct.move_order_line_id = mtrl.line_id
8049: AND wct.organization_id = mtrl.organization_id