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

Line 1569: wsh_delivery_assignments_v wda,

1565: )
1566: ) wv_qty,
1567: wdd.requested_quantity requested_quantity
1568: FROM wsh_delivery_details wdd,
1569: wsh_delivery_assignments_v wda,
1570: wsh_delivery_details wdd1,
1571: wsh_new_deliveries wnd
1572: where wdd.delivery_detail_id = p_delivery_detail_id
1573: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 1584: FROM wsh_delivery_assignments_v

1580: --
1581: CURSOR packed_csr(p_wdd_id NUMBER)
1582: IS
1583: SELECT parent_delivery_Detail_id
1584: FROM wsh_delivery_assignments_v
1585: WHERE delivery_Detail_id = p_wdd_id;
1586:
1587:
1588: temp_lpn NUMBER;

Line 2207: -- Updating wsh_delivery_assignments_v after the insert into wsh_delivery_details.

2203: WSH_DEBUG_SV.logmsg(l_module_name,'updating WDA');
2204: WSH_DEBUG_SV.log(l_module_name,'p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i))',p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i)));
2205: END IF;
2206:
2207: -- Updating wsh_delivery_assignments_v after the insert into wsh_delivery_details.
2208:
2209: update wsh_delivery_assignments_v
2210: set delivery_id = p_dd_rec.delivery_id_tab(i),
2211: last_update_date = SYSDATE,

Line 2209: update wsh_delivery_assignments_v

2205: END IF;
2206:
2207: -- Updating wsh_delivery_assignments_v after the insert into wsh_delivery_details.
2208:
2209: update wsh_delivery_assignments_v
2210: set delivery_id = p_dd_rec.delivery_id_tab(i),
2211: last_update_date = SYSDATE,
2212: last_updated_by = FND_GLOBAL.USER_ID,
2213: last_update_login = FND_GLOBAL.LOGIN_ID

Line 2749: update wsh_delivery_assignments_v

2745: WSH_DEBUG_SV.log(l_module_name,'p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i))',p_line_rec.delivery_detail_id(p_dd_rec.shpmt_line_id_idx_tab(i)));
2746: END IF;
2747: -- updating delivery assignments
2748:
2749: update wsh_delivery_assignments_v
2750: set delivery_id = p_dd_rec.delivery_id_tab(i),
2751: last_update_date = SYSDATE,
2752: last_updated_by = FND_GLOBAL.USER_ID,
2753: last_update_login = FND_GLOBAL.LOGIN_ID

Line 3776: wsh_delivery_assignments_v WDA,

3772: Wda.parent_delivery_detail_id,
3773: wdd.po_shipment_line_id
3774: FROM
3775: WSH_DELIVERY_DETAILS WDD,
3776: wsh_delivery_assignments_v WDA,
3777: WSH_NEW_DELIVERIES WND
3778: WHERE wdd.delivery_detail_id = wda.delivery_detail_id and
3779: wdd.line_direction not in ('O','IO') and
3780: Wda.delivery_id = wnd.delivery_id and

Line 3894: wsh_delivery_assignments_v wda,

3890: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
3891: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID
3892: where delivery_detail_id in (select wdd.delivery_detail_id
3893: from wsh_delivery_details wdd,
3894: wsh_delivery_assignments_v wda,
3895: wsh_new_deliveries wnd
3896: where wdd.delivery_detail_id = wda.delivery_detail_id
3897: and wda.delivery_id = wnd.delivery_id
3898: and wnd.asn_shipment_header_id = p_header_id

Line 4262: wsh_delivery_assignments_v wda

4258: SELECT
4259: wdd.delivery_detail_id
4260: FROM
4261: wsh_delivery_details wdd,
4262: wsh_delivery_assignments_v wda
4263: WHERE
4264: wdd.delivery_detail_id = wda.delivery_detail_id AND
4265: wda.delivery_id = p_del_id AND
4266: wdd.released_status = 'X';

Line 4274: wsh_delivery_assignments_v wda

4270: SELECT
4271: wdd.delivery_detail_id, nvl(wdd.container_flag,'N') container_flag
4272: FROM
4273: wsh_delivery_details wdd,
4274: wsh_delivery_assignments_v wda
4275: WHERE
4276: wdd.delivery_detail_id = wda.delivery_detail_id AND
4277: wda.delivery_id = v_del_id AND
4278: wdd.released_status in ('X', 'C');

Line 4287: wsh_delivery_assignments_v wda,

4283: SELECT
4284: wdd.delivery_detail_id, nvl(wdd.container_flag,'N') container_flag
4285: FROM
4286: wsh_delivery_details wdd,
4287: wsh_delivery_assignments_v wda,
4288: wsh_new_deliveries wnd
4289: WHERE
4290: wdd.delivery_detail_id = wda.delivery_detail_id AND
4291: wda.delivery_id = wnd.delivery_id AND

Line 4298: wsh_delivery_assignments_v wda1

4294: and not exists
4295: (
4296: SELECT 1
4297: FROM wsh_delivery_details wdd1,
4298: wsh_delivery_assignments_v wda1
4299: WHERE wdd1.delivery_detail_id = wda1.delivery_detail_id
4300: AND wda1.delivery_id = wnd.delivery_id
4301: AND wdd1.released_status in ( 'L')
4302: );

Line 4424: --{ --Deleting the rows in wsh_delivery_assignments_v corresponding to the selected LPNs.

4420: -- Also the delivery detail IDs for which these are assigned as LPNs(parent delivery detail Id)
4421: -- should be updated.
4422: IF lpn_ids_tab.COUNT > 0
4423: THEN
4424: --{ --Deleting the rows in wsh_delivery_assignments_v corresponding to the selected LPNs.
4425: FORALL i IN lpn_ids_tab.FIRST..lpn_ids_tab.LAST
4426: DELETE wsh_delivery_assignments_v
4427: WHERE delivery_detail_id = lpn_ids_tab(i);
4428:

Line 4426: DELETE wsh_delivery_assignments_v

4422: IF lpn_ids_tab.COUNT > 0
4423: THEN
4424: --{ --Deleting the rows in wsh_delivery_assignments_v corresponding to the selected LPNs.
4425: FORALL i IN lpn_ids_tab.FIRST..lpn_ids_tab.LAST
4426: DELETE wsh_delivery_assignments_v
4427: WHERE delivery_detail_id = lpn_ids_tab(i);
4428:
4429: IF l_debug_on THEN
4430: WSH_DEBUG_SV.log(l_module_name,'SQL%ROWCOUNT After delete LPN from WDA',SQL%ROWCOUNT);

Line 4444: UPDATE wsh_delivery_assignments_v

4440: END IF;
4441:
4442: --updating the rows in WDA for which the selected LPNs are parent Delivery Details.
4443: FORALL i IN lpn_ids_tab.FIRST..lpn_ids_tab.LAST
4444: UPDATE wsh_delivery_assignments_v
4445: SET parent_delivery_detail_id = NULL
4446: WHERE parent_delivery_detail_id = lpn_ids_tab(i);
4447:
4448: IF l_debug_on THEN

Line 4676: FROM wsh_delivery_assignments_v wda,

4672: cursor c_get_del_id_trip_id (p_del_detail_id NUMBER)
4673: is
4674: select wda.delivery_id,
4675: wt.trip_id
4676: FROM wsh_delivery_assignments_v wda,
4677: wsh_delivery_legs wdl,
4678: wsh_trip_stops wts,
4679: wsh_trips wt
4680: WHERE wda.delivery_detail_id = p_del_detail_id

Line 4689: FROM wsh_delivery_assignments_v wda,

4685: --Cursor to get the Trip ID for a Delivery ID.
4686: cursor c_get_trip_id (p_delivery_id NUMBER)
4687: is
4688: select wt.trip_id
4689: FROM wsh_delivery_assignments_v wda,
4690: wsh_delivery_legs wdl,
4691: wsh_trip_stops wts,
4692: wsh_trips wt
4693: WHERE wda.delivery_id = p_delivery_id

Line 4703: l_del_id_to_assign wsh_delivery_assignments_v.delivery_id%type;

4699:
4700: l_new_trip_id_count NUMBER;
4701: l_new_trip_ids wsh_util_core.id_tab_type;
4702: l_del_ids wsh_util_core.id_tab_type;
4703: l_del_id_to_assign wsh_delivery_assignments_v.delivery_id%type;
4704: l_return_status VARCHAR2(1);
4705: l_num_warnings NUMBER := 0;
4706: l_num_errors NUMBER := 0;
4707: l_index NUMBER;

Line 5227: FROM wsh_delivery_assignments_v wda

5223: WHERE wnd.asn_shipment_header_id = p_shipment_header_id
5224: AND wnd.status_code = 'IT'
5225: AND NOT EXISTS (
5226: select 1
5227: FROM wsh_delivery_assignments_v wda
5228: WHERE wda.delivery_id = wnd.delivery_id
5229: );
5230:
5231: l_stored_del_id NUMBER;

Line 7026: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd

7022:
7023: CURSOR lpn_csr(p_delivery_detail_id IN NUMBER)
7024: IS
7025: SELECT parent_delivery_detail_id, wdd.last_update_date
7026: FROM wsh_delivery_assignments_v wda, wsh_delivery_details wdd
7027: WHERE wda.delivery_detail_id = p_delivery_detail_id
7028: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id;
7029: --
7030: l_lpn_id NUMBER;