APPS.WSH_USA_CATEGORIES_PVT dependencies on WSH_DELIVERY_ASSIGNMENTS

Line 901: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd

897: wdd.weight_uom_code, wdd.volume_uom_code,
898: wdd.original_subinventory, wdd.pickable_flag ,
899: NVL(wnd.status_code, 'OP'), NVL(wnd.planned_flag, 'N'), NVL(wnd.tms_interface_flag, 'NS'),
900: wdd.replenishment_status
901: from wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd
902: where wdd.source_line_id = p_attributes_rec.source_line_id
903: and wdd.source_code = p_source_code
904: and wdd.delivery_detail_id = wda.delivery_detail_id
905: and wda.delivery_id = wnd.delivery_id(+)

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

906: order by decode(wdd.released_status, 'Y', 1, 2);
907:
908: CURSOR c_del_status IS
909: SELECT wnd.status_code,wsp.export_screening_flag
910: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda, wsh_new_deliveries wnd,
911: wsh_shipping_parameters wsp
912: WHERE wdd.source_code = p_source_code
913: AND wdd.source_line_id = p_attributes_rec.source_line_id
914: AND wdd.delivery_detail_id = wda.delivery_detail_id

Line 935: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda

931: AND released_status IN ('S','Y','C','B');
932:
933: CURSOR c_packed_det IS
934: SELECT 'N'
935: FROM wsh_delivery_details wdd, wsh_delivery_assignments wda
936: WHERE wdd.source_line_id = p_attributes_rec.source_line_id
937: AND wdd.source_code = p_source_code
938: AND wdd.released_status <> 'D'
939: AND wdd.delivery_detail_id = wda.delivery_detail_id

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

2528: select wdd.delivery_detail_id, wdd.ship_from_location_id,
2529: wda.delivery_id, wda.parent_delivery_detail_id,
2530: wdd.released_status, wnd.service_level service_level, wnd.mode_of_transport mode_of_transport,
2531: wnd.carrier_id carrier_id, wnd.ship_method_code ship_method_code
2532: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_new_deliveries wnd
2533: where wdd.source_line_id = p_source_line_id
2534: and wdd.source_code = p_source_code
2535: and wdd.delivery_detail_id = wda.delivery_detail_id
2536: and wda.delivery_id = wnd.delivery_id

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

2538: select wdd.delivery_detail_id, wdd.ship_from_location_id,
2539: wda.delivery_id, wda.parent_delivery_detail_id,
2540: wdd.released_status, wddp.service_level service_level, wddp.mode_of_transport mode_of_transport,
2541: wddp.carrier_id carrier_id, wdd.ship_method_code ship_method_code
2542: from wsh_delivery_details wdd, wsh_delivery_assignments_v wda, wsh_delivery_details wddp
2543: where wdd.source_line_id = p_source_line_id
2544: and wdd.source_code = p_source_code
2545: and wdd.delivery_detail_id = wda.delivery_detail_id
2546: and wda.parent_delivery_detail_id = wddp.delivery_detail_id

Line 2551: from wsh_delivery_assignments_v

2547: and wda.delivery_id is null;
2548:
2549: cursor c_get_parent_container(p_child_id in number) is
2550: select parent_delivery_detail_id
2551: from wsh_delivery_assignments_v
2552: where delivery_detail_id = p_child_id;
2553:
2554:
2555: