APPS.WSH_DCP_PVT dependencies on WSH_DELIVERY_DETAILS

Line 664: from wsh_delivery_details wdd,

660: ol.ship_to_contact_id ol_ship_to_contact_id, ol.ship_to_org_id,
661: ol.fulfilled_quantity, ol.invoiced_quantity,
662: oh.order_number, oh.ship_from_org_id,
663: wnd.delivery_id, wnd.status_code dlvy_status_code, wts.status_code stop_status_code, wdl.delivery_leg_id
664: from wsh_delivery_details wdd,
665: oe_order_lines_all ol,
666: oe_order_headers_all oh,
667: wsh_delivery_assignments_v wda,
668: wsh_new_deliveries wnd,

Line 700: from wsh_delivery_details wdd,

696: ol.ship_to_contact_id ol_ship_to_contact_id, ol.ship_to_org_id,
697: ol.fulfilled_quantity, ol.invoiced_quantity,
698: oh.order_number, oh.ship_from_org_id,
699: wnd.delivery_id, wnd.status_code dlvy_status_code, wts.status_code stop_status_code, wdl.delivery_leg_id
700: from wsh_delivery_details wdd,
701: oe_order_lines_all ol,
702: oe_order_headers_all oh,
703: wsh_delivery_assignments_v wda,
704: wsh_new_deliveries wnd,

Line 735: from wsh_delivery_details wdd,

731: ol.ship_to_contact_id ol_ship_to_contact_id, ol.ship_to_org_id,
732: ol.fulfilled_quantity, ol.invoiced_quantity,
733: oh.order_number, oh.ship_from_org_id,
734: wnd.delivery_id, wnd.status_code dlvy_status_code, wts.status_code stop_status_code, wdl.delivery_leg_id
735: from wsh_delivery_details wdd,
736: oe_order_lines_all ol,
737: oe_order_headers_all oh,
738: wsh_delivery_assignments_v wda,
739: wsh_new_deliveries wnd,

Line 771: from wsh_delivery_details wdd,

767: ol.ship_to_contact_id ol_ship_to_contact_id, ol.ship_to_org_id,
768: ol.fulfilled_quantity, ol.invoiced_quantity,
769: oh.order_number, oh.ship_from_org_id,
770: wnd.delivery_id, wnd.status_code dlvy_status_code, wts.status_code stop_status_code, wdl.delivery_leg_id
771: from wsh_delivery_details wdd,
772: oe_order_lines_all ol,
773: oe_order_headers_all oh,
774: wsh_delivery_assignments_v wda,
775: wsh_new_deliveries wnd,

Line 790: from wsh_delivery_details wdd,

786: and wdl.pick_up_stop_id = wts.stop_id (+);
787:
788: CURSOR c2_hdr IS
789: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
790: from wsh_delivery_details wdd,
791: oe_order_lines_all ol
792: where wdd.source_code = 'OE'
793: and wdd.source_line_id = ol.line_id
794: and nvl(wdd.ship_tolerance_above,0) = 0

Line 801: from wsh_delivery_details wdd1

797: and (wdd.released_status = 'D' or wdd.requested_quantity = 0)
798: and (ol.ordered_quantity > 0 or ol.cancelled_flag = 'N')
799: and not exists (
800: select 'x'
801: from wsh_delivery_details wdd1
802: where wdd1.source_line_id = wdd.source_line_id
803: and wdd1.delivery_detail_id <> wdd.delivery_detail_id
804: and (wdd1.released_status <> 'D' or wdd1.requested_quantity > 0))
805: and nvl(ol.shippable_flag, 'N') = 'Y';

Line 809: from wsh_delivery_details wdd,

805: and nvl(ol.shippable_flag, 'N') = 'Y';
806:
807: CURSOR c2_line IS
808: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
809: from wsh_delivery_details wdd,
810: oe_order_lines_all ol
811: where wdd.source_code = 'OE'
812: and wdd.source_line_id = ol.line_id
813: and nvl(wdd.ship_tolerance_above,0) = 0

Line 820: from wsh_delivery_details wdd1

816: and (wdd.released_status = 'D' or wdd.requested_quantity = 0)
817: and (ol.ordered_quantity > 0 or ol.cancelled_flag = 'N')
818: and not exists (
819: select 'x'
820: from wsh_delivery_details wdd1
821: where wdd1.source_line_id = wdd.source_line_id
822: and wdd1.delivery_detail_id <> wdd.delivery_detail_id
823: and (wdd1.released_status <> 'D' or wdd1.requested_quantity > 0))
824: and nvl(ol.shippable_flag, 'N') = 'Y';

Line 828: from wsh_delivery_details wdd,

824: and nvl(ol.shippable_flag, 'N') = 'Y';
825:
826: CURSOR c2_dlvy IS
827: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
828: from wsh_delivery_details wdd,
829: oe_order_lines_all ol,
830: wsh_delivery_assignments_v wda
831: where wdd.source_code = 'OE'
832: and wdd.source_line_id = ol.line_id

Line 842: from wsh_delivery_details wdd1

838: and (wdd.released_status = 'D' or wdd.requested_quantity = 0)
839: and (ol.ordered_quantity > 0 or ol.cancelled_flag = 'N')
840: and not exists (
841: select 'x'
842: from wsh_delivery_details wdd1
843: where wdd1.source_line_id = wdd.source_line_id
844: and wdd1.delivery_detail_id <> wdd.delivery_detail_id
845: and (wdd1.released_status <> 'D' or wdd1.requested_quantity > 0))
846: and nvl(ol.shippable_flag, 'N') = 'Y';

Line 850: from wsh_delivery_details wdd,

846: and nvl(ol.shippable_flag, 'N') = 'Y';
847:
848: CURSOR c2_batch IS
849: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
850: from wsh_delivery_details wdd,
851: oe_order_lines_all ol
852: where wdd.source_code = 'OE'
853: and wdd.source_line_id = ol.line_id
854: and nvl(wdd.ship_tolerance_above,0) = 0

Line 861: from wsh_delivery_details wdd1

857: and (wdd.released_status = 'D' or wdd.requested_quantity = 0)
858: and (ol.ordered_quantity > 0 or ol.cancelled_flag = 'N')
859: and not exists (
860: select 'x'
861: from wsh_delivery_details wdd1
862: where wdd1.source_line_id = wdd.source_line_id
863: and wdd1.delivery_detail_id <> wdd.delivery_detail_id
864: and (wdd1.released_status <> 'D' or wdd1.requested_quantity > 0))
865: and nvl(ol.shippable_flag, 'N') = 'Y';

Line 870: from wsh_delivery_details wdd,

866:
867:
868: CURSOR C12_hdr IS
869: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
870: from wsh_delivery_details wdd,
871: oe_order_lines_all ol
872: where wdd.source_code = 'OE'
873: and wdd.source_header_id = p_source_header_id
874: and wdd.source_line_id = ol.line_id

Line 889: from wsh_delivery_details wdd,

885: and wdd.released_status <> 'D';
886:
887: CURSOR C12_line IS
888: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
889: from wsh_delivery_details wdd,
890: oe_order_lines_all ol
891: where wdd.source_code = 'OE'
892: and wdd.source_line_id = p_source_line_id
893: and wdd.source_line_id = ol.line_id

Line 908: from wsh_delivery_details wdd,

904: and wdd.released_status <> 'D';
905:
906: CURSOR C12_dlvy IS
907: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
908: from wsh_delivery_details wdd,
909: wsh_delivery_assignments_v wda,
910: oe_order_lines_all ol
911: where wdd.source_code = 'OE'
912: and wdd.source_line_id = ol.line_id

Line 930: from wsh_delivery_details wdd,

926: and wdd.released_status <> 'D';
927:
928: CURSOR C12_batch IS
929: select wdd.source_header_number, wdd.source_line_number, wdd.delivery_detail_id
930: from wsh_delivery_details wdd,
931: oe_order_lines_all ol
932: where wdd.source_code = 'OE'
933: and wdd.batch_id = p_batch_id
934: and wdd.source_line_id = ol.line_id

Line 961: from wsh_delivery_details wdd

957: and ol.shipping_interfaced_flag = 'Y'
958: and nvl(ol.shippable_flag, 'N') = 'Y'
959: and not exists (
960: select 'x'
961: from wsh_delivery_details wdd
962: where wdd.source_code = 'OE'
963: and wdd.source_line_id = ol.line_id);
964:
965: CURSOR C6_line IS

Line 976: from wsh_delivery_details wdd

972: and ol.shipping_interfaced_flag = 'Y'
973: and nvl(ol.shippable_flag, 'N') = 'Y'
974: and not exists (
975: select 'x'
976: from wsh_delivery_details wdd
977: where wdd.source_code = 'OE'
978: and wdd.source_line_id = ol.line_id);
979:
980: --Prompt 32. Orphan reservations against closed lines

Line 1000: from wsh_delivery_details wdd

996: and mr.primary_reservation_quantity > 0
997: )
998: and not exists (
999: select 'x'
1000: from wsh_delivery_details wdd
1001: where wdd.source_line_id = oel.line_id
1002: and wdd.source_code = 'OE'
1003: and wdd.inv_interfaced_flag in ('N','P'))
1004: order by 1,2;

Line 1024: from wsh_delivery_details wdd

1020: and mr.primary_reservation_quantity > 0
1021: )
1022: and not exists (
1023: select 'x'
1024: from wsh_delivery_details wdd
1025: where wdd.source_line_id = oel.line_id
1026: and wdd.source_code = 'OE'
1027: and wdd.inv_interfaced_flag in ('N','P'))
1028: order by 1,2;