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

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

Line 7831: wsh_delivery_details wdd ,

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

Line 7925: FROM wsh_delivery_details wdd ,

7921: UPDATE wms_cartonization_temp
7922: SET cartonization_id = l_carton_lpn_id
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

Line 7961: wsh_delivery_details wdd ,

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

Line 7978: wsh_delivery_details wdd ,

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

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

7995: END IF;
7996:
7997: IF (l_del_det_id_tab.COUNT > 0 ) THEN
7998: IF (g_trace_on = 1) THEN
7999: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );
8000: END IF;
8001: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_del_det_id_tab,
8002: x_grouping_rows => l_grouping_rows,
8003: x_return_status => l_return_status);

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

7997: IF (l_del_det_id_tab.COUNT > 0 ) THEN
7998: IF (g_trace_on = 1) THEN
7999: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );
8000: END IF;
8001: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping( p_line_rows => l_del_det_id_tab,
8002: x_grouping_rows => l_grouping_rows,
8003: x_return_status => l_return_status);
8004: IF l_return_status = 'E' THEN
8005: IF (g_trace_on = 1) THEN

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

8002: x_grouping_rows => l_grouping_rows,
8003: x_return_status => l_return_status);
8004: IF l_return_status = 'E' THEN
8005: IF (g_trace_on = 1) THEN
8006: log_event('API WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping returned Error' );
8007: END IF;
8008: x_return_status := fnd_api.g_ret_sts_unexp_error ;
8009: RETURN;
8010: END IF;

Line 8037: FROM wsh_delivery_details wdd ,

8033: UPDATE wms_cartonization_temp
8034: SET cartonization_id = l_carton_lpn_id
8035: WHERE transaction_temp_id IN
8036: (SELECT wct.transaction_temp_id
8037: FROM wsh_delivery_details wdd ,
8038: wms_cartonization_temp wct,
8039: mtl_txn_request_lines mtrl
8040: WHERE wdd.delivery_detail_id = l_del_det_id_tab (i)
8041: AND wct.pick_slip_number = l_pick_slip

Line 8114: wsh_delivery_details wdd ,

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

Line 8133: wsh_delivery_details wdd ,

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

Line 8327: FROM wsh_delivery_details wdd,

8323: END IF;
8324:
8325: SELECT DISTINCT wdd.delivery_detail_id BULK COLLECT
8326: INTO l_del_det_id_tab
8327: FROM wsh_delivery_details wdd,
8328: wms_cartonization_temp wct,
8329: mtl_txn_request_lines mtrl
8330: WHERE wct.move_order_line_id = mtrl.line_id
8331: AND mtrl.header_id = p_move_order_header_id

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

8343:
8344: IF (l_del_det_id_tab.COUNT > 0 ) THEN
8345:
8346: IF (g_trace_on = 1) THEN
8347: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );
8348: END IF;
8349:
8350: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping
8351: (

Line 8350: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping

8346: IF (g_trace_on = 1) THEN
8347: log_event('calling WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping' );
8348: END IF;
8349:
8350: WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping
8351: (
8352: p_line_rows => l_del_det_id_tab,
8353: x_grouping_rows => l_grouping_rows,
8354: x_return_status => l_return_status

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

8355: );
8356:
8357: IF NVL(l_return_status,'E') = 'E' THEN
8358: IF (g_trace_on = 1) THEN
8359: log_event('API WSH_DELIVERY_DETAILS_GRP.Get_Carton_Grouping returned Error' );
8360: END IF;
8361: RAISE L_INVALID_CARTONIZATION;
8362: END IF;
8363: