APPS.WMS_CONTAINER2_PUB dependencies on WSH_DELIVERY_DETAILS

Line 1540: wsh_delivery_details wdd,

1536:
1537: CURSOR pick_delivery_cursor IS
1538: SELECT wda.delivery_id
1539: FROM wsh_delivery_assignments wda,
1540: wsh_delivery_details wdd,
1541: mtl_material_transactions_temp temp
1542: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1543: AND wdd.move_order_line_id = temp.move_order_line_id
1544: AND wdd.organization_id = temp.organization_id

Line 1551: wsh_delivery_details wdd,

1547:
1548: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
1549: SELECT wda.delivery_id
1550: FROM wsh_delivery_assignments wda,
1551: wsh_delivery_details wdd,
1552: wms_license_plate_numbers lpn
1553: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
1554: AND wdd.lpn_id = lpn.lpn_id
1555: AND lpn.outermost_lpn_id = l_lpn_id

Line 1772: FROM wsh_delivery_details

1768: SELECT 'x'
1769: FROM dual
1770: WHERE EXISTS (
1771: SELECT 'x'
1772: FROM wsh_delivery_details
1773: WHERE lpn_id = l_lpn_id
1774: AND organization_id = p_organization_id
1775: );
1776:

Line 1780: wsh_delivery_details wdd,

1776:
1777: CURSOR pick_delivery_cursor IS
1778: SELECT wda.delivery_id
1779: FROM wsh_delivery_assignments wda,
1780: wsh_delivery_details wdd,
1781: mtl_material_transactions_temp temp
1782: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
1783: AND wdd.move_order_line_id = temp.move_order_line_id
1784: AND wdd.organization_id = temp.organization_id

Line 1791: wsh_delivery_details wdd

1787:
1788: CURSOR drop_delivery_cursor(l_lpn_id IN NUMBER) IS
1789: SELECT wda.delivery_id
1790: FROM wsh_delivery_assignments wda,
1791: wsh_delivery_details wdd
1792: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
1793: AND wdd.lpn_id = l_lpn_id
1794: AND wdd.organization_id = p_organization_id;
1795:

Line 2093: wsh_delivery_details wdd,

2089:
2090: CURSOR pick_delivery_cursor IS
2091: SELECT wda.delivery_id
2092: FROM wsh_delivery_assignments wda,
2093: wsh_delivery_details wdd,
2094: mtl_material_transactions_temp temp
2095: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
2096: AND wdd.move_order_line_id = temp.move_order_line_id
2097: AND wdd.organization_id = temp.organization_id

Line 2106: wsh_delivery_details wdd,

2102: l_drop_sub_c IN VARCHAR2,
2103: l_drop_loc_c IN NUMBER ) IS
2104: SELECT wlpn.outermost_lpn_id
2105: FROM wsh_delivery_assignments wda,
2106: wsh_delivery_details wdd,
2107: wms_license_plate_numbers wlpn
2108: WHERE wda.delivery_id = l_delivery_id_c
2109: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id
2110: AND wdd.organization_id = p_organization_id