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_V

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: )