APPS.WSH_FREIGHT_COSTS_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 1005: FROM wsh_delivery_assignments_v b,

1001: conversion_rate
1002: FROM wsh_freight_costs a
1003: WHERE a.delivery_detail_id in (
1004: SELECT c.delivery_detail_id
1005: FROM wsh_delivery_assignments_v b,
1006: wsh_delivery_details c
1007: WHERE b.delivery_id = c_delivery_id AND
1008: c.delivery_detail_id = b.delivery_detail_id AND
1009: c.released_status <> 'D' ) AND

Line 1294: FROM wsh_delivery_assignments_v wda

1290: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Get_LPN_Freight_Cost';
1291:
1292: CURSOR c_getchildren (p_detailid NUMBER) IS
1293: SELECT delivery_detail_id
1294: FROM wsh_delivery_assignments_v wda
1295: WHERE LEVEL <= 10
1296: START WITH delivery_detail_id = p_detailid
1297: CONNECT BY PRIOR delivery_detail_id = parent_delivery_detail_id;
1298:

Line 1499: from wsh_delivery_assignments_v wda, wsh_delivery_details wdd

1495: --l_container_flag_no varchar2(1) ; -- BugFix3788678
1496:
1497: cursor c_get_contindel(p_delid NUMBER) is
1498: select wdd.delivery_detail_id
1499: from wsh_delivery_assignments_v wda, wsh_delivery_details wdd
1500: where wda.delivery_detail_id=wdd.delivery_detail_id
1501: and wdd.container_flag= 'Y'
1502: and wda.delivery_id=p_delid
1503: and wda.parent_delivery_detail_id is null;

Line 1507: from wsh_delivery_assignments_v wda, wsh_delivery_details wdd

1503: and wda.parent_delivery_detail_id is null;
1504:
1505: cursor c_get_ddindel(p_delid NUMBER) is
1506: select wdd.delivery_detail_id
1507: from wsh_delivery_assignments_v wda, wsh_delivery_details wdd
1508: where wda.delivery_detail_id=wdd.delivery_detail_id
1509: and wdd.container_flag= 'N'
1510: and wda.delivery_id=p_delid
1511: and wda.parent_delivery_detail_id is null;

Line 2220: FROM wsh_delivery_assignments_v b,

2216: conversion_rate
2217: FROM wsh_freight_costs a
2218: WHERE a.delivery_detail_id in (
2219: SELECT c.delivery_detail_id
2220: FROM wsh_delivery_assignments_v b,
2221: wsh_delivery_details c
2222: WHERE b.delivery_id = c_delivery_id AND
2223: c.delivery_detail_id = b.delivery_detail_id AND
2224: c.released_status <> 'D') AND

Line 2234: FROM wsh_delivery_legs wshlg, wsh_delivery_assignments_v wshda,

2230:
2231:
2232: Cursor need_reprice(c_delivery_id NUMBER) IS
2233: SELECT 1
2234: FROM wsh_delivery_legs wshlg, wsh_delivery_assignments_v wshda,
2235: wsh_new_deliveries wshnd
2236: WHERE wshlg.delivery_id = c_delivery_id AND
2237: wshlg.reprice_required = 'Y' AND
2238: wshnd.delivery_id = wshlg.delivery_id and