APPS.WSH_USA_CATEGORIES_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 922: , wsh_delivery_assignments wda

918: , NVL(wnd.tms_interface_flag, 'NS')
919: , wdd.replenishment_status
920: , wdd.client_id -- LSP PROJECT
921: from wsh_delivery_details wdd
922: , wsh_delivery_assignments wda
923: , wsh_new_deliveries wnd
924: where wdd.source_line_id = p_attributes_rec.source_line_id
925: and wdd.source_code = p_source_code
926: and wdd.delivery_detail_id = wda.delivery_detail_id

Line 932: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd,

928: order by decode(wdd.released_status, 'Y', 1, 2);
929:
930: CURSOR c_del_status IS
931: SELECT wnd.status_code,wsp.export_screening_flag
932: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd,
933: wsh_shipping_parameters wsp
934: WHERE wdd.source_code = p_source_code
935: AND wdd.source_line_id = p_attributes_rec.source_line_id
936: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 958: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

954: AND released_status IN ('S','Y','C');
955:
956: CURSOR c_packed_det IS
957: SELECT 'N'
958: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
959: WHERE wdd.source_line_id = p_attributes_rec.source_line_id
960: AND wdd.source_code = p_source_code
961: AND wdd.released_status <> 'D'
962: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 2690: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd

2686: select wdd.delivery_detail_id, wdd.ship_from_location_id,
2687: wda.delivery_id, wda.parent_delivery_detail_id,
2688: wdd.released_status, wnd.service_level service_level, wnd.mode_of_transport mode_of_transport,
2689: wnd.carrier_id carrier_id, wnd.ship_method_code ship_method_code
2690: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2691: where wdd.source_line_id = p_source_line_id
2692: and wdd.source_code = p_source_code
2693: and wdd.delivery_detail_id = wda.delivery_detail_id
2694: and wda.delivery_id = wnd.delivery_id

Line 2700: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_delivery_details wddp

2696: select wdd.delivery_detail_id, wdd.ship_from_location_id,
2697: wda.delivery_id, wda.parent_delivery_detail_id,
2698: wdd.released_status, wddp.service_level service_level, wddp.mode_of_transport mode_of_transport,
2699: wddp.carrier_id carrier_id, wdd.ship_method_code ship_method_code
2700: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_delivery_details wddp
2701: where wdd.source_line_id = p_source_line_id
2702: and wdd.source_code = p_source_code
2703: and wdd.delivery_detail_id = wda.delivery_detail_id
2704: and wda.parent_delivery_detail_id = wddp.delivery_detail_id

Line 2709: from wsh_delivery_assignments_v

2705: and wda.delivery_id is null;
2706:
2707: cursor c_get_parent_container(p_child_id in number) is
2708: select parent_delivery_detail_id
2709: from wsh_delivery_assignments_v
2710: where delivery_detail_id = p_child_id;
2711:
2712:
2713: