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_DETAILS

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 7723: wsh_delivery_details wdd ,

7719: IS
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

Line 7742: wsh_delivery_details wdd ,

7738: IS
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

Line 7836: FROM wsh_delivery_details wdd ,

7832: UPDATE wms_cartonization_temp
7833: SET cartonization_id = l_carton_lpn_id
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

Line 7872: wsh_delivery_details wdd ,

7868: SELECT wdd.delivery_detail_id BULK COLLECT
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

Line 7889: wsh_delivery_details wdd ,

7885: SELECT wdd.delivery_detail_id BULK COLLECT
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

Line 7910: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );

7906: END IF;
7907:
7908: IF (l_del_det_id_tab.COUNT > 0 ) THEN
7909: IF (g_trace_on = 1) THEN
7910: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );
7911: END IF;
7912: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_del_det_id_tab,
7913: x_grouping_rows => l_grouping_rows,
7914: x_return_status => l_return_status);

Line 7912: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_del_det_id_tab,

7908: IF (l_del_det_id_tab.COUNT > 0 ) THEN
7909: IF (g_trace_on = 1) THEN
7910: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );
7911: END IF;
7912: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_del_det_id_tab,
7913: x_grouping_rows => l_grouping_rows,
7914: x_return_status => l_return_status);
7915: IF l_return_status = 'E' THEN
7916: IF (g_trace_on = 1) THEN

Line 7917: log_event('API WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping returned Error' );

7913: x_grouping_rows => l_grouping_rows,
7914: x_return_status => l_return_status);
7915: IF l_return_status = 'E' THEN
7916: IF (g_trace_on = 1) THEN
7917: log_event('API WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping returned Error' );
7918: END IF;
7919: x_return_status := fnd_api.g_ret_sts_unexp_error ;
7920: RETURN;
7921: END IF;

Line 7948: FROM wsh_delivery_details wdd ,

7944: UPDATE wms_cartonization_temp
7945: SET cartonization_id = l_carton_lpn_id
7946: WHERE transaction_temp_id IN
7947: (SELECT wct.transaction_temp_id
7948: FROM wsh_delivery_details wdd ,
7949: wms_cartonization_temp wct,
7950: mtl_txn_request_lines mtrl
7951: WHERE wdd.delivery_detail_id = l_del_det_id_tab (i)
7952: AND wct.pick_slip_number = l_pick_slip

Line 8025: wsh_delivery_details wdd ,

8021: IS
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

Line 8044: wsh_delivery_details wdd ,

8040: IS
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

Line 8232: FROM wsh_delivery_details wdd,

8228: END IF;
8229:
8230: SELECT DISTINCT wdd.delivery_detail_id BULK COLLECT
8231: INTO l_del_det_id_tab
8232: FROM wsh_delivery_details wdd,
8233: wms_cartonization_temp wct,
8234: mtl_txn_request_lines mtrl
8235: WHERE wct.move_order_line_id = mtrl.line_id
8236: AND mtrl.header_id = p_move_order_header_id

Line 8252: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );

8248:
8249: IF (l_del_det_id_tab.COUNT > 0 ) THEN
8250:
8251: IF (g_trace_on = 1) THEN
8252: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );
8253: END IF;
8254:
8255: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping
8256: (

Line 8255: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping

8251: IF (g_trace_on = 1) THEN
8252: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );
8253: END IF;
8254:
8255: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping
8256: (
8257: p_line_rows => l_del_det_id_tab,
8258: x_grouping_rows => l_grouping_rows,
8259: x_return_status => l_return_status

Line 8264: log_event('API WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping returned Error' );

8260: );
8261:
8262: IF NVL(l_return_status,'E') = 'E' THEN
8263: IF (g_trace_on = 1) THEN
8264: log_event('API WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping returned Error' );
8265: END IF;
8266: RAISE L_INVALID_CARTONIZATION;
8267: END IF;
8268: