APPS.WMS_PICK_DROP_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 255: FROM wsh_delivery_assignments_v wda,

251: CURSOR c_get_deliv_id
252: ( p_tmp_id IN NUMBER
253: ) IS
254: SELECT wda.delivery_id
255: FROM wsh_delivery_assignments_v wda,
256: wsh_delivery_details_ob_grp_v wdd,
257: mtl_material_transactions_temp mmtt
258: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
259: AND wdd.move_order_line_id = mmtt.move_order_line_id

Line 279: FROM wsh_delivery_assignments_v wda,

275:
276: IF p_drop_type = 'CONS_STG_MV' THEN
277: SELECT wda.delivery_id
278: INTO x_delivery_id
279: FROM wsh_delivery_assignments_v wda,
280: wsh_delivery_details_ob_grp_v wdd,
281: mtl_material_transactions_temp mmtt
282: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
283: AND wdd.organization_id = mmtt.organization_id

Line 949: , wsh_delivery_assignments_v wda

945: )
946: FROM mtl_material_transactions_temp mmtt
947: , mtl_txn_request_lines mtrl
948: , wsh_delivery_details_ob_grp_v wdd
949: , wsh_delivery_assignments_v wda
950: WHERE mmtt.organization_id = p_org_id
951: --Modified for Bug 6717052
952: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn
953: WHERE wlpn.outermost_lpn_id = p_lpn_id))

Line 3363: , wsh_delivery_assignments_v wda

3359: , mtl_secondary_inventories msi
3360: , mtl_item_locations mil
3361: , mtl_txn_request_lines mtrl
3362: , wsh_delivery_details_ob_grp_v wdd
3363: , wsh_delivery_assignments_v wda
3364: WHERE mmtt.organization_id = p_org_id
3365: AND mmtt.transfer_lpn_id = p_lpn_id
3366: AND mmtt.transaction_action_id = 28
3367: AND ( (mmtt.parent_line_id IS NOT NULL

Line 4252: FROM wsh_delivery_assignments_v wda

4248: , p_subinv IN VARCHAR2
4249: , p_loc_id IN NUMBER
4250: ) IS
4251: SELECT wlpn.outermost_lpn_id
4252: FROM wsh_delivery_assignments_v wda
4253: , wsh_delivery_details_ob_grp_v wdd
4254: , wms_license_plate_numbers wlpn
4255: WHERE wda.delivery_id = p_deliv_id
4256: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 7399: , wsh_delivery_assignments_v wda

7395: , p_org_id IN NUMBER
7396: ) IS
7397: SELECT wda.delivery_id
7398: FROM wsh_delivery_details_ob_grp_v wdd
7399: , wsh_delivery_assignments_v wda
7400: WHERE wdd.lpn_id = p_lpn_id
7401: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
7402: AND wdd.organization_id = p_org_id
7403: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id;

Line 7417: , wsh_delivery_assignments_v wda

7413: , wda.delivery_id
7414: FROM mtl_material_transactions_temp mmtt
7415: , mtl_txn_request_lines mtrl
7416: , wsh_delivery_details_ob_grp_v wdd
7417: , wsh_delivery_assignments_v wda
7418: WHERE mmtt.organization_id = p_org_id
7419: AND mmtt.transfer_lpn_id = p_lpn_id
7420: AND mmtt.move_order_line_id = mtrl.line_id
7421: AND mtrl.line_id = wdd.move_order_line_id (+)

Line 7433: , wsh_delivery_assignments_v wda

7429: , p_org_id IN NUMBER
7430: ) IS
7431: SELECT mtrl.carton_grouping_id
7432: FROM wsh_delivery_details_ob_grp_v wdd
7433: , wsh_delivery_assignments_v wda
7434: , wsh_delivery_details_ob_grp_v wdd2
7435: , mtl_txn_request_lines mtrl
7436: WHERE wdd.lpn_id = p_lpn_id
7437: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650

Line 10204: FROM wsh_delivery_assignments_v wda

10200: ( p_del_id IN NUMBER
10201: ) IS
10202: SELECT MIN(ooha.order_number)
10203: , COUNT(DISTINCT ooha.order_number)
10204: FROM wsh_delivery_assignments_v wda
10205: , wsh_delivery_details_ob_grp_v wdd
10206: , oe_order_lines_all oola
10207: , oe_order_headers_all ooha
10208: WHERE wda.delivery_id = p_del_id

Line 10469: FROM wsh_delivery_assignments_v wda

10465: ( p_lpn_id IN NUMBER
10466: , p_org_id IN NUMBER
10467: ) IS
10468: SELECT wda.delivery_id
10469: FROM wsh_delivery_assignments_v wda
10470: , wsh_delivery_details_ob_grp_v wdd
10471: , wms_license_plate_numbers lpn
10472: WHERE wda.parent_delivery_detail_id = wdd.delivery_detail_id
10473: AND wdd.organization_id = p_org_id