APPS.WSH_CONTAINER_GRP dependencies on WSH_NEW_DELIVERIES

Line 1134: FROM wsh_new_deliveries

1130: IS
1131: SELECT delivery_id
1132: , name
1133: , status_code
1134: FROM wsh_new_deliveries
1135: WHERE delivery_id = v_del_id
1136: AND NVL(shipment_direction,'O') IN ('O','IO'); -- J-IB-NPARIKH;
1137:
1138: --added by adagur for bug 16397445

Line 2060: l_dlvy_status_code wsh_new_deliveries.status_code%TYPE;

2056: l_verify_status_lvl NUMBER ;
2057: l_verify_org NUMBER ;
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;

Line 2094: FROM WSH_NEW_DELIVERIES

2090: AND nvl(wdd.line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH
2091:
2092: CURSOR Check_Delivery_by_id (v_del_id NUMBER) IS
2093: SELECT delivery_id, name, status_code
2094: FROM WSH_NEW_DELIVERIES
2095: WHERE delivery_id = v_del_id;
2096:
2097: CURSOR Check_Delivery_by_Name ( v_del_name VARCHAR2) IS
2098: SELECT delivery_id, name, status_code

Line 2099: FROM WSH_NEW_DELIVERIES

2095: WHERE delivery_id = v_del_id;
2096:
2097: CURSOR Check_Delivery_by_Name ( v_del_name VARCHAR2) IS
2098: SELECT delivery_id, name, status_code
2099: FROM WSH_NEW_DELIVERIES
2100: WHERE name = v_del_name;
2101:
2102: CURSOR c_dlvy(l_delivery_id number) IS
2103: SELECT status_code

Line 2104: FROM wsh_new_deliveries

2100: WHERE name = v_del_name;
2101:
2102: CURSOR c_dlvy(l_delivery_id number) IS
2103: SELECT status_code
2104: FROM wsh_new_deliveries
2105: WHERE delivery_id = l_delivery_id;
2106:
2107: -- K LPN CONV. rv
2108: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;