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

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 1442: FROM wsh_delivery_assignments_v

1438: ) IS
1439:
1440: CURSOR c_topmost_container IS
1441: SELECT delivery_detail_id
1442: FROM wsh_delivery_assignments_v
1443: WHERE parent_delivery_detail_id is null
1444: START WITH delivery_detail_id =p_detail_id
1445: CONNECT BY prior parent_delivery_detail_id = delivery_detail_id
1446: and rownum < 10;

Line 1456: FROM wsh_delivery_assignments wda

1452: SELECT 1
1453: FROM dual
1454: WHERE EXISTS
1455: ( SELECT 'x'
1456: FROM wsh_delivery_assignments wda
1457: , wsh_delivery_details wdd
1458: WHERE wda.delivery_id = p_delv_id
1459: AND (wda.type IN ('S', 'O') OR
1460: wda.type IS NULL)

Line 1470: FROM wsh_delivery_assignments wda

1466: SELECT 1
1467: FROM dual
1468: WHERE EXISTS
1469: ( SELECT 'x'
1470: FROM wsh_delivery_assignments wda
1471: , wsh_delivery_details wdd
1472: WHERE wda.delivery_id = p_delv_id
1473: AND (wda.type IN ('S', 'O') OR
1474: wda.type IS NULL)

Line 1838: FROM wsh_delivery_assignments

1834: x_return_status OUT NOCOPY VARCHAR2) IS
1835:
1836: CURSOR c_get_delivery_id(p_id IN NUMBER) IS
1837: SELECT delivery_id
1838: FROM wsh_delivery_assignments
1839: WHERE delivery_detail_id = p_id;
1840:
1841: CURSOR c_get_gross_weight (p_id NUMBER) IS
1842: SELECT nvl(gross_weight, 0)

Line 2252: FROM wsh_delivery_assignments_v wda

2248: WHERE delivery_id = v_delivery_id;
2249:
2250: CURSOR c_get_content_count(v_delivery_detail_id NUMBER) IS
2251: SELECT count(*)
2252: FROM wsh_delivery_assignments_v wda
2253: WHERE wda.parent_delivery_detail_id = v_delivery_detail_id And rownum = 1;
2254: -- Bug 3715176
2255:
2256: -- Bug 4452930

Line 2259: FROM wsh_delivery_assignments_v

2255:
2256: -- Bug 4452930
2257: CURSOR c_topmost_container(p_detail_id NUMBER) IS
2258: SELECT delivery_detail_id
2259: FROM wsh_delivery_assignments_v
2260: WHERE parent_delivery_detail_id is null
2261: START WITH delivery_detail_id =p_detail_id
2262: CONNECT BY prior parent_delivery_detail_id = delivery_detail_id
2263: and rownum < 10;

Line 3219: UPDATE wsh_delivery_assignments_v

3215: END IF;
3216: -- K LPN CONV. rv
3217: --
3218:
3219: UPDATE wsh_delivery_assignments_v
3220: SET parent_delivery_detail_id = p_parent_detail_id,
3221: delivery_id = l_del_id_for_container.delivery_id,
3222: last_update_date = SYSDATE,
3223: last_updated_by = FND_GLOBAL.USER_ID,

Line 3330: UPDATE wsh_delivery_assignments_v

3326: END IF;
3327: -- K LPN CONV. rv
3328: --
3329:
3330: UPDATE wsh_delivery_assignments_v
3331: SET parent_delivery_detail_id = p_parent_detail_id,
3332: last_update_date = SYSDATE,
3333: last_updated_by = FND_GLOBAL.USER_ID,
3334: last_update_login = FND_GLOBAL.LOGIN_ID

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

3357: IF ( (l_del_id_for_detail.delivery_id is not null)
3358: AND (l_del_id_for_container.delivery_id is null) ) THEN
3359:
3360: -- K LPN CONV. rv
3361: -- Based on assumption that we are using wsh_delivery_assignments_v,
3362: -- delivery and its contents will belong to same organization.
3363: -- Similarly, container and its contents will belong to same organization.
3364: -- Hence, we are checking for WMS org or non-WMS org. at the
3365: -- parent level (i.e. delivery/container)

Line 3369: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of

3365: -- parent level (i.e. delivery/container)
3366: -- rather than at line-level for performance reasons.
3367:
3368: -- If this assumptions were to be violated in anyway
3369: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
3370: -- wsh_delivery_assignments_v
3371: -- or
3372: -- if existing query were to somehow return/fetch records where
3373: -- delivery and its contents may belong to diff. org.

Line 3370: -- wsh_delivery_assignments_v

3366: -- rather than at line-level for performance reasons.
3367:
3368: -- If this assumptions were to be violated in anyway
3369: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
3370: -- wsh_delivery_assignments_v
3371: -- or
3372: -- if existing query were to somehow return/fetch records where
3373: -- delivery and its contents may belong to diff. org.
3374: -- container and its contents may belong to diff. org.

Line 3478: UPDATE wsh_delivery_assignments_v

3474: END IF;
3475: --
3476:
3477: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
3478: UPDATE wsh_delivery_assignments_v
3479: SET delivery_id = l_del_id_FOR_detail.delivery_id,
3480: last_update_date = SYSDATE,
3481: last_updated_by = FND_GLOBAL.USER_ID,
3482: last_update_login = FND_GLOBAL.LOGIN_ID

Line 3871: UPDATE wsh_delivery_assignments_v

3867: --}
3868: END IF;
3869: -- K LPN CONV. rv
3870: --
3871: UPDATE wsh_delivery_assignments_v
3872: SET parent_delivery_detail_id = NULL,
3873: last_update_date = SYSDATE,
3874: last_updated_by = FND_GLOBAL.USER_ID,
3875: last_update_login = FND_GLOBAL.LOGIN_ID

Line 4166: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda

4162: mode_of_transport, carrier_id, service_level,
4163: wda.parent_delivery_detail_id, -- K LPN CONV. rv
4164: wdd.gross_weight, -- OTM R12 : assign delivery detail
4165: wdd.client_id -- LSP PROJECT
4166: FROM wsh_delivery_details wdd, wsh_delivery_assignments_v wda
4167: WHERE wdd.delivery_detail_id = wda.delivery_detail_id and wdd.delivery_detail_id = c_detail_id;
4168:
4169:
4170: l_detail c_detail%ROWTYPE;

Line 4176: FROM wsh_delivery_assignments_v

4172: l_del_assign NUMBER;
4173:
4174: CURSOR c_all_details_below IS
4175: SELECT delivery_detail_id
4176: FROM wsh_delivery_assignments_v
4177: START WITH delivery_detail_id = p_detail_id
4178: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id;
4179:
4180: CURSOR c_getdet_ignore IS

Line 4872: UPDATE wsh_delivery_assignments

4868: END IF;
4869: -- K LPN CONV. rv
4870: --
4871:
4872: UPDATE wsh_delivery_assignments
4873: SET delivery_id = p_delivery_id,
4874: last_update_date = SYSDATE,
4875: last_updated_by = FND_GLOBAL.USER_ID,
4876: last_update_login = FND_GLOBAL.LOGIN_ID

Line 5367: FROM wsh_delivery_assignments_v

5363: --Modified cursor check_loop
5364: /*
5365: CURSOR check_loop(x_delivery_detail_id NUMBER) IS
5366: SELECT delivery_detail_id
5367: FROM wsh_delivery_assignments_v
5368: START WITH delivery_detail_id = x_delivery_detail_id
5369: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
5370: */
5371:

Line 5384: FROM wsh_delivery_assignments_v

5380:
5381:
5382: CURSOR check_loop(p_inner_cont_id NUMBER,p_outer_cont_id NUMBER) IS
5383: SELECT delivery_detail_id
5384: FROM wsh_delivery_assignments_v
5385: WHERE delivery_detail_id = p_outer_cont_id
5386: START WITH delivery_detail_id = p_inner_cont_id
5387: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id;
5388:

Line 5397: FROM wsh_delivery_assignments_v wda

5393: WHERE delivery_id = v_delivery_id;
5394:
5395: CURSOR c_get_content_count(v_delivery_detail_id NUMBER) IS
5396: SELECT count(*)
5397: FROM wsh_delivery_assignments_v wda
5398: WHERE wda.parent_delivery_detail_id = v_delivery_detail_id and rownum = 1;
5399: -- Bug 3715176
5400:
5401: /* Commenting this out - Bug 2457558

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

6125:
6126: IF (l_del_id_for_container2.delivery_id IS NULL) THEN
6127: /* Bug 1571143,Combining the 2 cursors */
6128: -- K LPN CONV. rv
6129: -- Based on assumption that we are using wsh_delivery_assignments_v,
6130: -- delivery and its contents will belong to same organization.
6131: -- Similarly, container and its contents will belong to same organization.
6132: -- Hence, we are checking for WMS org or non-WMS org. at the
6133: -- parent level (i.e. delivery/container)

Line 6137: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of

6133: -- parent level (i.e. delivery/container)
6134: -- rather than at line-level for performance reasons.
6135:
6136: -- If this assumptions were to be violated in anyway
6137: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
6138: -- wsh_delivery_assignments_v
6139: -- or
6140: -- if existing query were to somehow return/fetch records where
6141: -- delivery and its contents may belong to diff. org.

Line 6138: -- wsh_delivery_assignments_v

6134: -- rather than at line-level for performance reasons.
6135:
6136: -- If this assumptions were to be violated in anyway
6137: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
6138: -- wsh_delivery_assignments_v
6139: -- or
6140: -- if existing query were to somehow return/fetch records where
6141: -- delivery and its contents may belong to diff. org.
6142: -- container and its contents may belong to diff. org.

Line 6202: UPDATE wsh_delivery_assignments_v

6198: END IF;
6199: --
6200:
6201: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
6202: UPDATE wsh_delivery_assignments_v
6203: SET delivery_id = l_del_id_for_container1.delivery_id,
6204: last_update_date = SYSDATE,
6205: last_updated_by = FND_GLOBAL.USER_ID,
6206: last_update_login = FND_GLOBAL.LOGIN_ID

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

6288: ELSIF (l_del_id_FOR_container2.delivery_id IS NOT NULL) THEN
6289:
6290: /* Bug 1571143 ,Combining the 2 cursors */
6291: -- K LPN CONV. rv
6292: -- Based on assumption that we are using wsh_delivery_assignments_v,
6293: -- delivery and its contents will belong to same organization.
6294: -- Similarly, container and its contents will belong to same organization.
6295: -- Hence, we are checking for WMS org or non-WMS org. at the
6296: -- parent level (i.e. delivery/container)

Line 6300: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of

6296: -- parent level (i.e. delivery/container)
6297: -- rather than at line-level for performance reasons.
6298:
6299: -- If this assumptions were to be violated in anyway
6300: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
6301: -- wsh_delivery_assignments_v
6302: -- or
6303: -- if existing query were to somehow return/fetch records where
6304: -- delivery and its contents may belong to diff. org.

Line 6301: -- wsh_delivery_assignments_v

6297: -- rather than at line-level for performance reasons.
6298:
6299: -- If this assumptions were to be violated in anyway
6300: -- i.e Query was changed to refer to base table wsh_delivery_assignments instead of
6301: -- wsh_delivery_assignments_v
6302: -- or
6303: -- if existing query were to somehow return/fetch records where
6304: -- delivery and its contents may belong to diff. org.
6305: -- container and its contents may belong to diff. org.

Line 6366: UPDATE wsh_delivery_assignments_v

6362: END IF;
6363: --
6364:
6365: FORALL i in l_sync_tmp_recTbl.delivery_detail_id_tbl.first..l_sync_tmp_recTbl.delivery_detail_id_tbl.last
6366: UPDATE wsh_delivery_assignments_v
6367: SET delivery_id = l_del_id_for_container2.delivery_id,
6368: last_update_date = SYSDATE,
6369: last_updated_by = FND_GLOBAL.USER_ID,
6370: last_update_login = FND_GLOBAL.LOGIN_ID

Line 6476: UPDATE wsh_delivery_assignments_v

6472: --}
6473: END IF;
6474: -- K LPN CONV. rv
6475: --
6476: UPDATE wsh_delivery_assignments_v
6477: SET parent_delivery_detail_id = p_detail_id2,
6478: last_update_date = SYSDATE,
6479: last_updated_by = FND_GLOBAL.USER_ID,
6480: last_update_login = FND_GLOBAL.LOGIN_ID

Line 6742: FROM wsh_delivery_assignments_v wda,

6738: wdd.organization_id,
6739: wdd.weight_uom_code,
6740: wdd.volume_uom_code,
6741: wdd.inventory_item_id
6742: FROM wsh_delivery_assignments_v wda,
6743: wsh_delivery_details wdd
6744: WHERE wda.delivery_detail_id = p_detail_id
6745: and wdd.delivery_detail_id = wda.delivery_detail_id
6746: and ((wda.delivery_id IS not null) or (wda.parent_delivery_detail_id IS not null));

Line 6777: FROM wsh_delivery_assignments_v

6773: CURSOR c_all_details_below IS
6774: SELECT delivery_detail_id,
6775: parent_delivery_detail_id, -- LPN CONV. rv
6776: delivery_id -- LPN CONV. rv
6777: FROM wsh_delivery_assignments_v
6778: START WITH delivery_detail_id = p_detail_id
6779: CONNECT BY prior delivery_detail_id = parent_delivery_detail_id;
6780:
6781: -- J: W/V Changes

Line 7154: UPDATE wsh_delivery_assignments_v

7150: --}
7151: END IF;
7152: -- K LPN CONV. rv
7153: --
7154: UPDATE wsh_delivery_assignments_v
7155: SET delivery_id = l_null_delivery_id, --bugfix 3768823
7156: last_update_date = SYSDATE,
7157: last_updated_by = FND_GLOBAL.USER_ID,
7158: last_update_login = FND_GLOBAL.LOGIN_ID

Line 7504: UPDATE wsh_delivery_assignments_v

7500: --}
7501: END IF;
7502: -- K LPN CONV. rv
7503: --
7504: UPDATE wsh_delivery_assignments_v
7505: SET parent_delivery_detail_id=NULL
7506: WHERE delivery_detail_id = p_detail_id;
7507:
7508: --OTM Dock Door Appt Sched Proj

Line 7818: FROM wsh_delivery_assignments_v

7814:
7815: CURSOR c_multi_assign_rec(c_delivery_detail_id number)
7816: IS
7817: SELECT delivery_id, parent_delivery_detail_id
7818: FROM wsh_delivery_assignments_v
7819: WHERE delivery_detail_id = c_delivery_Detail_id
7820: AND ((delivery_id IS not null) or (parent_delivery_detail_id IS not null));
7821: l_multi_assign_rec c_multi_assign_rec%ROWTYPE;
7822:

Line 7857: FROM wsh_delivery_assignments_v wda

7853: SELECT wnd.delivery_id, wnd.organization_id
7854: FROM wsh_new_deliveries wnd
7855: WHERE wnd.delivery_id = p_del_id and wnd.shipment_direction='I'
7856: and not exists ( SELECT wda.delivery_id
7857: FROM wsh_delivery_assignments_v wda
7858: WHERE wda.delivery_id =wnd.delivery_id );
7859: l_del_id NUMBER;
7860: l_org_id NUMBER;
7861: l_wf_rs VARCHAR2(1);

Line 8531: FROM wsh_delivery_assignments_v

8527:
8528:
8529: CURSOR c_get_del_from_container(c_container_id number) IS
8530: SELECT delivery_id
8531: FROM wsh_delivery_assignments_v
8532: WHERE delivery_detail_id = c_container_id;
8533:
8534: l_num_errors NUMBER;
8535: l_num_warnings NUMBER;

Line 12077: FROM wsh_delivery_assignments_v

12073:
12074: CURSOR get_container(detail_id NUMBER) IS
12075: SELECT parent_delivery_detail_id,
12076: delivery_id -- Bug#3542095
12077: FROM wsh_delivery_assignments_v
12078: WHERE delivery_detail_id = detail_id;
12079:
12080: CURSOR get_lines (cont_id NUMBER, detail_id NUMBER) IS
12081: SELECT delivery_detail_id

Line 12082: FROM wsh_delivery_assignments_v

12078: WHERE delivery_detail_id = detail_id;
12079:
12080: CURSOR get_lines (cont_id NUMBER, detail_id NUMBER) IS
12081: SELECT delivery_detail_id
12082: FROM wsh_delivery_assignments_v
12083: WHERE parent_delivery_detail_id = cont_id
12084: AND delivery_detail_id <> detail_id;
12085:
12086: l_parent_container_id wsh_util_core.id_tab_type ;

Line 12087: l_delivery_id wsh_delivery_assignments_v.delivery_id%type;

12083: WHERE parent_delivery_detail_id = cont_id
12084: AND delivery_detail_id <> detail_id;
12085:
12086: l_parent_container_id wsh_util_core.id_tab_type ;
12087: l_delivery_id wsh_delivery_assignments_v.delivery_id%type;
12088: l_return_status VARCHAR2(1):=NULL ;
12089: l_line_id NUMBER := NULL;
12090:
12091: -- K LPN CONV. rv

Line 12629: wsh_delivery_assignments_v wda

12625:
12626: CURSOR get_bo_dds_cur(p_delivery_detail_id IN NUMBER, p_source_line_id IN NUMBER,p_delivery_id IN NUMBER) is
12627: SELECT wdd.delivery_detail_id, wdd.requested_quantity,wdd.requested_quantity2
12628: FROM wsh_delivery_details wdd,
12629: wsh_delivery_assignments_v wda
12630: WHERE wdd.source_line_id = p_source_line_id
12631: AND wdd.delivery_detail_id <> p_delivery_detail_id
12632: AND wdd.released_status = 'B'
12633: AND wdd.replenishment_status IS NULL --bug# 6749200 (replenishment project)

Line 13934: update wsh_delivery_assignments

13930:
13931: x_return_status := FND_API.G_RET_STS_SUCCESS;
13932:
13933: FORALL i in p_detail_id_tab.first..p_detail_id_tab.LAST
13934: update wsh_delivery_assignments
13935: set type = 'S'
13936: where type = 'O'
13937: and delivery_detail_id = p_detail_id_tab(i);
13938:

Line 13942: delete from wsh_delivery_assignments

13938:
13939: IF sql%found THEN
13940:
13941: FORALL i in p_detail_id_tab.first..p_detail_id_tab.LAST
13942: delete from wsh_delivery_assignments
13943: where delivery_detail_id = p_detail_id_tab(i)
13944: and type = 'C';
13945:
13946: END IF;

Line 13970: from wsh_delivery_legs l1, wsh_delivery_legs l2, wsh_delivery_assignments a

13966: x_return_status OUT NOCOPY VARCHAR2) IS
13967:
13968: cursor c_get_consolidation_delivery (p_det_id IN NUMBER) is
13969: select l1.delivery_id, l2.delivery_id
13970: from wsh_delivery_legs l1, wsh_delivery_legs l2, wsh_delivery_assignments a
13971: where a.delivery_detail_id = p_det_id
13972: and l1.delivery_id = a.delivery_id
13973: and l1.parent_delivery_leg_id = l2.delivery_leg_id
13974: and a.parent_delivery_detail_id is NULL

Line 14030: update wsh_delivery_assignments

14026: IF l_debug_on THEN
14027: WSH_DEBUG_SV.logmsg(l_module_name, 'updating tabcount', l_detail_id_tab.count);
14028: END IF;
14029: FORALL i in l_detail_id_tab.first..l_detail_id_tab.count
14030: update wsh_delivery_assignments
14031: set type = 'O',
14032: parent_delivery_detail_id = NULL
14033: where NVL(type, 'S') = 'S'
14034: and delivery_detail_id = l_detail_id_tab(i);

Line 14037: INSERT INTO wsh_delivery_assignments (

14033: where NVL(type, 'S') = 'S'
14034: and delivery_detail_id = l_detail_id_tab(i);
14035:
14036: FORALL i in l_detail_id_tab.first..l_detail_id_tab.count
14037: INSERT INTO wsh_delivery_assignments (
14038: delivery_id,
14039: parent_delivery_id,
14040: delivery_detail_id,
14041: parent_delivery_detail_id,

Line 14069: wsh_delivery_assignments_s.nextval,

14065: NULL,
14066: NULL,
14067: NULL,
14068: NULL,
14069: wsh_delivery_assignments_s.nextval,
14070: 'C'
14071: );
14072:
14073: