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_DELIVERY_DETAILS_ACTIONS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 26: wsh_delivery_assignments_v wda

22: volume,
23: container_flag,
24: delivery_id
25: from wsh_Delivery_details wdd,
26: wsh_delivery_assignments_v wda
27: where wdd.delivery_detail_id = detail_id
28: and wdd.delivery_detail_id = wda.delivery_detail_id;
29:
30: -- odaboval : End of OPM Changes (Pick_Confirm)

Line 170: wsh_delivery_assignments_v wda

166: wdd.date_scheduled, -- 2847687
167: wda.parent_delivery_detail_id --4721577
168: from wsh_delivery_details wdd ,
169: oe_order_lines_all o,
170: wsh_delivery_assignments_v wda
171: where wdd.delivery_detail_id = p_delivery_Detail_id
172: and wdd.delivery_detail_id = wda.delivery_detail_id
173: and wdd.source_code = 'OE'
174: and wdd.source_line_id = o.line_id ;

Line 1356: FROM wsh_delivery_assignments_v

1352: ) IS
1353:
1354: CURSOR c_topmost_container IS
1355: SELECT delivery_detail_id
1356: FROM wsh_delivery_assignments_v
1357: WHERE parent_delivery_detail_id is null
1358: START WITH delivery_detail_id =p_detail_id
1359: CONNECT BY prior parent_delivery_detail_id = delivery_detail_id
1360: and rownum < 10;

Line 1376: FROM wsh_delivery_assignments_v wda,

1372: ),
1373: NULL
1374: )
1375: ) picked_lines_count
1376: FROM wsh_delivery_assignments_v wda,
1377: wsh_delivery_details wdd
1378: WHERE
1379: wda.delivery_detail_id= wdd.delivery_detail_id AND
1380: wdd.container_flag = 'N' AND

Line 2146: FROM wsh_delivery_assignments_v wda

2142: WHERE delivery_id = v_delivery_id;
2143:
2144: CURSOR c_get_content_count(v_delivery_detail_id NUMBER) IS
2145: SELECT count(*)
2146: FROM wsh_delivery_assignments_v wda
2147: WHERE wda.parent_delivery_detail_id = v_delivery_detail_id And rownum = 1;
2148: -- Bug 3715176
2149:
2150: -- Bug 4452930

Line 2153: FROM wsh_delivery_assignments_v

2149:
2150: -- Bug 4452930
2151: CURSOR c_topmost_container(p_detail_id NUMBER) IS
2152: SELECT delivery_detail_id
2153: FROM wsh_delivery_assignments_v
2154: WHERE parent_delivery_detail_id is null
2155: START WITH delivery_detail_id =p_detail_id
2156: CONNECT BY prior parent_delivery_detail_id = delivery_detail_id
2157: and rownum < 10;

Line 3074: UPDATE wsh_delivery_assignments_v

3070: END IF;
3071: -- K LPN CONV. rv
3072: --
3073:
3074: UPDATE wsh_delivery_assignments_v
3075: SET parent_delivery_detail_id = p_parent_detail_id,
3076: delivery_id = l_del_id_for_container.delivery_id,
3077: last_update_date = SYSDATE,
3078: last_updated_by = FND_GLOBAL.USER_ID,

Line 3185: UPDATE wsh_delivery_assignments_v

3181: END IF;
3182: -- K LPN CONV. rv
3183: --
3184:
3185: UPDATE wsh_delivery_assignments_v
3186: SET parent_delivery_detail_id = p_parent_detail_id,
3187: last_update_date = SYSDATE,
3188: last_updated_by = FND_GLOBAL.USER_ID,
3189: last_update_login = FND_GLOBAL.LOGIN_ID

Line 3216: -- Based on assumption that we are using wsh_delivery_assignments_v,

3212: IF ( (l_del_id_for_detail.delivery_id is not null)
3213: AND (l_del_id_for_container.delivery_id is null) ) THEN
3214:
3215: -- K LPN CONV. rv
3216: -- Based on assumption that we are using wsh_delivery_assignments_v,
3217: -- delivery and its contents will belong to same organization.
3218: -- Similarly, container and its contents will belong to same organization.
3219: -- Hence, we are checking for WMS org or non-WMS org. at the
3220: -- parent level (i.e. delivery/container)

Line 3225: -- wsh_delivery_assignments_v

3221: -- rather than at line-level for performance reasons.
3222:
3223: -- If this assumptions were to be violated in anyway
3224: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
3225: -- wsh_delivery_assignments_v
3226: -- or
3227: -- if existing query were to somehow return/fetch records where
3228: -- delivery and its contents may belong to diff. org.
3229: -- container and its contents may belong to diff. org.

Line 3333: UPDATE wsh_delivery_assignments_v

3329: END IF;
3330: --
3331:
3332: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
3333: UPDATE wsh_delivery_assignments_v
3334: SET delivery_id = l_del_id_FOR_detail.delivery_id,
3335: last_update_date = SYSDATE,
3336: last_updated_by = FND_GLOBAL.USER_ID,
3337: last_update_login = FND_GLOBAL.LOGIN_ID

Line 3726: UPDATE wsh_delivery_assignments_v

3722: --}
3723: END IF;
3724: -- K LPN CONV. rv
3725: --
3726: UPDATE wsh_delivery_assignments_v
3727: SET parent_delivery_detail_id = NULL,
3728: last_update_date = SYSDATE,
3729: last_updated_by = FND_GLOBAL.USER_ID,
3730: last_update_login = FND_GLOBAL.LOGIN_ID

Line 4019: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

4015: NVL(ignore_for_planning,'N') ignore_for_planning,--J TP Release ttrichy
4016: mode_of_transport, carrier_id, service_level,
4017: wda.parent_delivery_detail_id, -- K LPN CONV. rv
4018: wdd.gross_weight -- OTM R12 : assign delivery detail
4019: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
4020: WHERE wdd.delivery_detail_id = wda.delivery_detail_id and wdd.delivery_detail_id = c_detail_id;
4021:
4022:
4023: l_detail c_detail%ROWTYPE;

Line 4029: FROM wsh_delivery_assignments_v

4025: l_del_assign NUMBER;
4026:
4027: CURSOR c_all_details_below IS
4028: SELECT delivery_detail_id
4029: FROM wsh_delivery_assignments_v
4030: START WITH delivery_detail_id = p_detail_id
4031: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id;
4032:
4033: CURSOR c_getdet_ignore IS

Line 4721: UPDATE wsh_delivery_assignments_v

4717: END IF;
4718: -- K LPN CONV. rv
4719: --
4720:
4721: UPDATE wsh_delivery_assignments_v
4722: SET delivery_id = p_delivery_id,
4723: last_update_date = SYSDATE,
4724: last_updated_by = FND_GLOBAL.USER_ID,
4725: last_update_login = FND_GLOBAL.LOGIN_ID

Line 5214: FROM wsh_delivery_assignments_v

5210: --Modified cursor check_loop
5211: /*
5212: CURSOR check_loop(x_delivery_detail_id NUMBER) IS
5213: SELECT delivery_detail_id
5214: FROM wsh_delivery_assignments_v
5215: START WITH delivery_detail_id = x_delivery_detail_id
5216: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
5217: */
5218:

Line 5231: FROM wsh_delivery_assignments_v

5227:
5228:
5229: CURSOR check_loop(p_inner_cont_id NUMBER,p_outer_cont_id NUMBER) IS
5230: SELECT delivery_detail_id
5231: FROM wsh_delivery_assignments_v
5232: WHERE delivery_detail_id = p_outer_cont_id
5233: START WITH delivery_detail_id = p_inner_cont_id
5234: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id;
5235:

Line 5244: FROM wsh_delivery_assignments_v wda

5240: WHERE delivery_id = v_delivery_id;
5241:
5242: CURSOR c_get_content_count(v_delivery_detail_id NUMBER) IS
5243: SELECT count(*)
5244: FROM wsh_delivery_assignments_v wda
5245: WHERE wda.parent_delivery_detail_id = v_delivery_detail_id and rownum = 1;
5246: -- Bug 3715176
5247:
5248: /* Commenting this out - Bug 2457558

Line 5975: -- Based on assumption that we are using wsh_delivery_assignments_v,

5971:
5972: IF (l_del_id_for_container2.delivery_id IS NULL) THEN
5973: /* Bug 1571143,Combining the 2 cursors */
5974: -- K LPN CONV. rv
5975: -- Based on assumption that we are using wsh_delivery_assignments_v,
5976: -- delivery and its contents will belong to same organization.
5977: -- Similarly, container and its contents will belong to same organization.
5978: -- Hence, we are checking for WMS org or non-WMS org. at the
5979: -- parent level (i.e. delivery/container)

Line 5984: -- wsh_delivery_assignments_v

5980: -- rather than at line-level for performance reasons.
5981:
5982: -- If this assumptions were to be violated in anyway
5983: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
5984: -- wsh_delivery_assignments_v
5985: -- or
5986: -- if existing query were to somehow return/fetch records where
5987: -- delivery and its contents may belong to diff. org.
5988: -- container and its contents may belong to diff. org.

Line 6048: UPDATE wsh_delivery_assignments_v

6044: END IF;
6045: --
6046:
6047: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
6048: UPDATE wsh_delivery_assignments_v
6049: SET delivery_id = l_del_id_for_container1.delivery_id,
6050: last_update_date = SYSDATE,
6051: last_updated_by = FND_GLOBAL.USER_ID,
6052: last_update_login = FND_GLOBAL.LOGIN_ID

Line 6138: -- Based on assumption that we are using wsh_delivery_assignments_v,

6134: ELSIF (l_del_id_FOR_container2.delivery_id IS NOT NULL) THEN
6135:
6136: /* Bug 1571143 ,Combining the 2 cursors */
6137: -- K LPN CONV. rv
6138: -- Based on assumption that we are using wsh_delivery_assignments_v,
6139: -- delivery and its contents will belong to same organization.
6140: -- Similarly, container and its contents will belong to same organization.
6141: -- Hence, we are checking for WMS org or non-WMS org. at the
6142: -- parent level (i.e. delivery/container)

Line 6147: -- wsh_delivery_assignments_v

6143: -- rather than at line-level for performance reasons.
6144:
6145: -- If this assumptions were to be violated in anyway
6146: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
6147: -- wsh_delivery_assignments_v
6148: -- or
6149: -- if existing query were to somehow return/fetch records where
6150: -- delivery and its contents may belong to diff. org.
6151: -- container and its contents may belong to diff. org.

Line 6212: UPDATE wsh_delivery_assignments_v

6208: END IF;
6209: --
6210:
6211: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
6212: UPDATE wsh_delivery_assignments_v
6213: SET delivery_id = l_del_id_for_container2.delivery_id,
6214: last_update_date = SYSDATE,
6215: last_updated_by = FND_GLOBAL.USER_ID,
6216: last_update_login = FND_GLOBAL.LOGIN_ID

Line 6322: UPDATE wsh_delivery_assignments_v

6318: --}
6319: END IF;
6320: -- K LPN CONV. rv
6321: --
6322: UPDATE wsh_delivery_assignments_v
6323: SET parent_delivery_detail_id = p_detail_id2,
6324: last_update_date = SYSDATE,
6325: last_updated_by = FND_GLOBAL.USER_ID,
6326: last_update_login = FND_GLOBAL.LOGIN_ID

Line 6588: FROM wsh_delivery_assignments_v wda,

6584: wdd.organization_id,
6585: wdd.weight_uom_code,
6586: wdd.volume_uom_code,
6587: wdd.inventory_item_id
6588: FROM wsh_delivery_assignments_v wda,
6589: wsh_delivery_details wdd
6590: WHERE wda.delivery_detail_id = p_detail_id
6591: and wdd.delivery_detail_id = wda.delivery_detail_id
6592: and ((wda.delivery_id IS not null) or (wda.parent_delivery_detail_id IS not null));

Line 6623: FROM wsh_delivery_assignments_v

6619: CURSOR c_all_details_below IS
6620: SELECT delivery_detail_id,
6621: parent_delivery_detail_id, -- LPN CONV. rv
6622: delivery_id -- LPN CONV. rv
6623: FROM wsh_delivery_assignments_v
6624: START WITH delivery_detail_id = p_detail_id
6625: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id;
6626:
6627: -- J: W/V Changes

Line 6985: UPDATE wsh_delivery_assignments_v

6981: --}
6982: END IF;
6983: -- K LPN CONV. rv
6984: --
6985: UPDATE wsh_delivery_assignments_v
6986: SET delivery_id = l_null_delivery_id, --bugfix 3768823
6987: last_update_date = SYSDATE,
6988: last_updated_by = FND_GLOBAL.USER_ID,
6989: last_update_login = FND_GLOBAL.LOGIN_ID

Line 7340: UPDATE wsh_delivery_assignments_v

7336: --}
7337: END IF;
7338: -- K LPN CONV. rv
7339: --
7340: UPDATE wsh_delivery_assignments_v
7341: SET parent_delivery_detail_id=NULL
7342: WHERE delivery_detail_id = p_detail_id;
7343:
7344: --OTM Dock Door Appt Sched Proj

Line 7654: FROM wsh_delivery_assignments_v

7650:
7651: CURSOR c_multi_assign_rec(c_delivery_detail_id number)
7652: IS
7653: SELECT delivery_id, parent_delivery_detail_id
7654: FROM wsh_delivery_assignments_v
7655: WHERE delivery_detail_id = c_delivery_Detail_id
7656: AND ((delivery_id IS not null) or (parent_delivery_detail_id IS not null));
7657: l_multi_assign_rec c_multi_assign_rec%ROWTYPE;
7658:

Line 7693: FROM wsh_delivery_assignments_v wda

7689: SELECT wnd.delivery_id, wnd.organization_id
7690: FROM wsh_new_deliveries wnd
7691: WHERE wnd.delivery_id = p_del_id and wnd.shipment_direction='I'
7692: and not exists ( SELECT wda.delivery_id
7693: FROM wsh_delivery_assignments_v wda
7694: WHERE wda.delivery_id =wnd.delivery_id );
7695: l_del_id NUMBER;
7696: l_org_id NUMBER;
7697: l_wf_rs VARCHAR2(1);

Line 8367: FROM wsh_delivery_assignments_v

8363:
8364:
8365: CURSOR c_get_del_from_container(c_container_id number) IS
8366: SELECT delivery_id
8367: FROM wsh_delivery_assignments_v
8368: WHERE delivery_detail_id = c_container_id;
8369:
8370: l_num_errors NUMBER;
8371: l_num_warnings NUMBER;

Line 11612: FROM wsh_delivery_assignments_v

11608:
11609: CURSOR get_container(detail_id NUMBER) IS
11610: SELECT parent_delivery_detail_id,
11611: delivery_id -- Bug#3542095
11612: FROM wsh_delivery_assignments_v
11613: WHERE delivery_detail_id = detail_id;
11614:
11615: CURSOR get_lines (cont_id NUMBER, detail_id NUMBER) IS
11616: SELECT delivery_detail_id

Line 11617: FROM wsh_delivery_assignments_v

11613: WHERE delivery_detail_id = detail_id;
11614:
11615: CURSOR get_lines (cont_id NUMBER, detail_id NUMBER) IS
11616: SELECT delivery_detail_id
11617: FROM wsh_delivery_assignments_v
11618: WHERE parent_delivery_detail_id = cont_id
11619: AND delivery_detail_id <> detail_id;
11620:
11621: l_parent_container_id wsh_util_core.id_tab_type ;

Line 11622: l_delivery_id wsh_delivery_assignments_v.delivery_id%type;

11618: WHERE parent_delivery_detail_id = cont_id
11619: AND delivery_detail_id <> detail_id;
11620:
11621: l_parent_container_id wsh_util_core.id_tab_type ;
11622: l_delivery_id wsh_delivery_assignments_v.delivery_id%type;
11623: l_return_status VARCHAR2(1):=NULL ;
11624: l_line_id NUMBER := NULL;
11625:
11626: -- K LPN CONV. rv

Line 12164: wsh_delivery_assignments_v wda

12160:
12161: CURSOR get_bo_dds_cur(p_delivery_detail_id IN NUMBER, p_source_line_id IN NUMBER,p_delivery_id IN NUMBER) is
12162: SELECT wdd.delivery_detail_id, wdd.requested_quantity,wdd.requested_quantity2
12163: FROM wsh_delivery_details wdd,
12164: wsh_delivery_assignments_v wda
12165: WHERE wdd.source_line_id = p_source_line_id
12166: AND wdd.delivery_detail_id <> p_delivery_detail_id
12167: AND wdd.released_status = 'B'
12168: AND wdd.replenishment_status IS NULL --bug# 6749200 (replenishment project)