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.WSH_CONTAINER_GRP dependencies on WSH_DELIVERY_DETAILS

Line 441: -- container record in WSH_DELIVERY_DETAILS with the attributes input in the

437: -- 2) other standard parameters
438: --
439: -- Description: This procedure takes in a record of container attributes that
440: -- contains the name and delivery detail id of container to update the
441: -- container record in WSH_DELIVERY_DETAILS with the attributes input in the
442: -- container rec type. The API validates the container name and detail id and
443: -- calls the wsh_delivery_details_grp.update_shipping_attributes public API.
444:
445: -- THIS PROCEDURE SHOULD NOT BE USED ANYMORE, IT IS USED ONLY FOR BACKWARD

Line 443: -- calls the wsh_delivery_details_grp.update_shipping_attributes public API.

439: -- Description: This procedure takes in a record of container attributes that
440: -- contains the name and delivery detail id of container to update the
441: -- container record in WSH_DELIVERY_DETAILS with the attributes input in the
442: -- container rec type. The API validates the container name and detail id and
443: -- calls the wsh_delivery_details_grp.update_shipping_attributes public API.
444:
445: -- THIS PROCEDURE SHOULD NOT BE USED ANYMORE, IT IS USED ONLY FOR BACKWARD
446: -- COMPATIBILITY.
447: ------------------------------------------------------------------------------

Line 501: FROM WSH_DELIVERY_DETAILS

497:
498: --lpn conv
499: CURSOR Check_Cont (v_cont_id NUMBER ) IS
500: SELECT container_flag, delivery_detail_id, lpn_id, released_status
501: FROM WSH_DELIVERY_DETAILS
502: WHERE delivery_detail_id = v_cont_id
503: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
504:
505: CURSOR Check_Cont_Name (v_cont_name VARCHAR2) IS

Line 507: FROM WSH_DELIVERY_DETAILS

503: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
504:
505: CURSOR Check_Cont_Name (v_cont_name VARCHAR2) IS
506: SELECT delivery_detail_id, container_name
507: FROM WSH_DELIVERY_DETAILS
508: WHERE container_name = v_cont_name
509: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
510:
511: CURSOR c_get_lpn (l_delivery_detail_id NUMBER) IS

Line 513: FROM wsh_delivery_details

509: AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
510:
511: CURSOR c_get_lpn (l_delivery_detail_id NUMBER) IS
512: SELECT lpn_id
513: FROM wsh_delivery_details
514: WHERE delivery_detail_id = l_delivery_detail_id;
515:
516:
517: --

Line 1125: FROM wsh_delivery_details

1121: CURSOR Check_Detail (v_detail_id NUMBER)
1122: IS
1123: SELECT delivery_detail_id
1124: , container_flag
1125: FROM wsh_delivery_details
1126: WHERE delivery_detail_id = v_detail_id
1127: AND NVL(line_direction,'O') IN ('O','IO'); -- J-IB-NPARIKH;
1128:
1129: CURSOR Check_Delivery (v_del_id NUMBER)

Line 1144: FROM wsh_delivery_details wdd

1140: IS
1141: SELECT wdd.delivery_detail_id
1142: , wdd.container_flag
1143: , wdacnt.delivery_id
1144: FROM wsh_delivery_details wdd
1145: , wsh_delivery_assignments wda
1146: , wsh_delivery_assignments wdacnt
1147: WHERE wda.delivery_id IS NULL
1148: AND wda.delivery_detail_id = v_delivery_detail_id

Line 1156: FROM wsh_delivery_details wdd

1152: UNION
1153: SELECT wdd.delivery_detail_id
1154: , wdd.container_flag
1155: , wda.delivery_id
1156: FROM wsh_delivery_details wdd
1157: , wsh_delivery_assignments wda
1158: , wsh_delivery_assignments wdacnt
1159: WHERE wda.delivery_detail_id = v_delivery_detail_id
1160: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 1421: wsh_delivery_details_actions.Assign_Detail_to_Delivery

1417: , l_delivery_id;
1418:
1419: IF Get_cont_Detail_Id%FOUND
1420: THEN
1421: wsh_delivery_details_actions.Assign_Detail_to_Delivery
1422: ( p_detail_id => l_det_tab(i)
1423: , p_delivery_id => l_delivery_id
1424: , x_return_status => x_return_status) ;
1425: CLOSE Get_cont_Detail_Id;

Line 2062: l_cont_released_status wsh_delivery_details.released_status%TYPE;

2058: l_verify_dlvy NUMBER ;
2059: l_wms_enabled_flag VARCHAR2(10);
2060: l_dlvy_status_code wsh_new_deliveries.status_code%TYPE;
2061: l_cont_org_id NUMBER;
2062: l_cont_released_status wsh_delivery_details.released_status%TYPE;
2063: l_return_status VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2064: l_num_warning NUMBER := 0;
2065: l_num_errors NUMBER := 0;
2066: l_next NUMBER ;

Line 2078: FROM WSH_DELIVERY_DETAILS

2074:
2075: --Bug 4329611. Perf Fix .
2076: CURSOR Get_Detail_Id (v_cont_name VARCHAR2) IS
2077: SELECT delivery_detail_id, container_flag
2078: FROM WSH_DELIVERY_DETAILS
2079: WHERE container_name = v_cont_name
2080: --LPN reuse project
2081: AND released_status = 'X'
2082: AND container_flag = 'Y';

Line 2087: FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda

2083:
2084: CURSOR Check_Detail (v_detail_id NUMBER) IS
2085: SELECT wdd.delivery_detail_id, wdd.container_flag,wdd.released_status,
2086: wdd.organization_id ,wda.delivery_id
2087: FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda
2088: WHERE wdd.delivery_detail_id = v_detail_id
2089: AND wdd.delivery_detail_id = wda.delivery_detail_id
2090: AND nvl(wdd.line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH
2091: