APPS.WMS_CONTAINER2_PUB dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 1539: FROM wsh_delivery_assignments wda,

1535: AND organization_id = p_organization_id;
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

Line 1550: FROM wsh_delivery_assignments wda,

1546: AND temp.organization_id = p_organization_id ;
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

Line 1779: FROM wsh_delivery_assignments wda,

1775: );
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

Line 1790: FROM wsh_delivery_assignments wda,

1786: AND temp.organization_id = p_organization_id;
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;

Line 2092: FROM wsh_delivery_assignments wda,

2088:
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

Line 2105: FROM wsh_delivery_assignments wda,

2101: CURSOR drop_delivery_cursor (l_delivery_id_c IN NUMBER,
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