APPS.WSH_DCP_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 666: oe_order_headers_all oh,

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,
669: wsh_delivery_legs wdl,
670: wsh_trip_stops wts

Line 702: oe_order_headers_all oh,

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,
705: wsh_delivery_legs wdl,
706: wsh_trip_stops wts

Line 737: oe_order_headers_all oh,

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,
740: wsh_delivery_legs wdl,
741: wsh_trip_stops wts

Line 773: oe_order_headers_all oh,

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,
776: wsh_delivery_legs wdl,
777: wsh_trip_stops wts

Line 953: from oe_order_headers_all oh,

949: --Cursor #6
950: CURSOR C6_hdr IS
951: select oh.order_number,
952: RTRIM(ol.line_number || '.' || ol.shipment_number || '.' || ol.option_number || '.' || ol.component_number || '.' || ol.service_number, '.') line_number
953: from oe_order_headers_all oh,
954: oe_order_lines_all ol
955: where oh.header_id = ol.header_id
956: and oh.header_id = p_source_header_id
957: and ol.shipping_interfaced_flag = 'Y'

Line 968: from oe_order_headers_all oh,

964:
965: CURSOR C6_line IS
966: select oh.order_number,
967: RTRIM(ol.line_number || '.' || ol.shipment_number || '.' || ol.option_number || '.' || ol.component_number || '.' || ol.service_number, '.') line_number
968: from oe_order_headers_all oh,
969: oe_order_lines_all ol
970: where oh.header_id = ol.header_id
971: and ol.line_id = p_source_line_id
972: and ol.shipping_interfaced_flag = 'Y'

Line 986: from oe_order_headers_all oeh,

982: CURSOR C13_hdr IS
983: select oeh.order_number,
984: oel.line_id,
985: RTRIM(oel.line_number || '.' || oel.shipment_number || '.' || oel.option_number || '.' || oel.component_number || '.' || oel.service_number, '.') line_number
986: from oe_order_headers_all oeh,
987: oe_order_lines_all oel
988: where oeh.header_id = p_source_header_id
989: and oeh.header_id = oel.header_id
990: and oel.open_flag = 'N'

Line 1010: from oe_order_headers_all oeh,

1006: CURSOR C13_line IS
1007: select oeh.order_number,
1008: oel.line_id,
1009: RTRIM(oel.line_number || '.' || oel.shipment_number || '.' || oel.option_number || '.' || oel.component_number || '.' || oel.service_number, '.') line_number
1010: from oe_order_headers_all oeh,
1011: oe_order_lines_all oel
1012: where oel.line_id = p_source_line_id
1013: and oeh.header_id = oel.header_id
1014: and oel.open_flag = 'N'