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