37: wdd_ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
38: wdd_picked_quantity wsh_delivery_details.picked_quantity%TYPE,
39: wdd_cycle_count_quantity wsh_delivery_details.cycle_count_quantity%TYPE,
40: wdd_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
41: ol_line_id oe_order_lines_all.line_id%TYPE,
42: --Line number here is a concatenation of five different numbers
43: ol_line_number VARCHAR2(32767),
44: ol_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
45: ol_cancelled_flag oe_order_lines_all.cancelled_flag%TYPE,
40: wdd_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
41: ol_line_id oe_order_lines_all.line_id%TYPE,
42: --Line number here is a concatenation of five different numbers
43: ol_line_number VARCHAR2(32767),
44: ol_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
45: ol_cancelled_flag oe_order_lines_all.cancelled_flag%TYPE,
46: ol_ship_set_id oe_order_lines_all.ship_set_id%TYPE,
47: ol_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE,
48: ol_flow_status_code oe_order_lines_all.flow_status_code%TYPE,
41: ol_line_id oe_order_lines_all.line_id%TYPE,
42: --Line number here is a concatenation of five different numbers
43: ol_line_number VARCHAR2(32767),
44: ol_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
45: ol_cancelled_flag oe_order_lines_all.cancelled_flag%TYPE,
46: ol_ship_set_id oe_order_lines_all.ship_set_id%TYPE,
47: ol_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE,
48: ol_flow_status_code oe_order_lines_all.flow_status_code%TYPE,
49: ol_open_flag oe_order_lines_all.open_flag%TYPE,
42: --Line number here is a concatenation of five different numbers
43: ol_line_number VARCHAR2(32767),
44: ol_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
45: ol_cancelled_flag oe_order_lines_all.cancelled_flag%TYPE,
46: ol_ship_set_id oe_order_lines_all.ship_set_id%TYPE,
47: ol_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE,
48: ol_flow_status_code oe_order_lines_all.flow_status_code%TYPE,
49: ol_open_flag oe_order_lines_all.open_flag%TYPE,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,
43: ol_line_number VARCHAR2(32767),
44: ol_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
45: ol_cancelled_flag oe_order_lines_all.cancelled_flag%TYPE,
46: ol_ship_set_id oe_order_lines_all.ship_set_id%TYPE,
47: ol_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE,
48: ol_flow_status_code oe_order_lines_all.flow_status_code%TYPE,
49: ol_open_flag oe_order_lines_all.open_flag%TYPE,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,
51: ol_org_id oe_order_lines_all.org_id%TYPE,
44: ol_ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
45: ol_cancelled_flag oe_order_lines_all.cancelled_flag%TYPE,
46: ol_ship_set_id oe_order_lines_all.ship_set_id%TYPE,
47: ol_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE,
48: ol_flow_status_code oe_order_lines_all.flow_status_code%TYPE,
49: ol_open_flag oe_order_lines_all.open_flag%TYPE,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,
51: ol_org_id oe_order_lines_all.org_id%TYPE,
52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%TYPE,
45: ol_cancelled_flag oe_order_lines_all.cancelled_flag%TYPE,
46: ol_ship_set_id oe_order_lines_all.ship_set_id%TYPE,
47: ol_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE,
48: ol_flow_status_code oe_order_lines_all.flow_status_code%TYPE,
49: ol_open_flag oe_order_lines_all.open_flag%TYPE,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,
51: ol_org_id oe_order_lines_all.org_id%TYPE,
52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%TYPE,
53: ol_request_date oe_order_lines_all.request_date%TYPE,
46: ol_ship_set_id oe_order_lines_all.ship_set_id%TYPE,
47: ol_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE,
48: ol_flow_status_code oe_order_lines_all.flow_status_code%TYPE,
49: ol_open_flag oe_order_lines_all.open_flag%TYPE,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,
51: ol_org_id oe_order_lines_all.org_id%TYPE,
52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%TYPE,
53: ol_request_date oe_order_lines_all.request_date%TYPE,
54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_flag%TYPE,
47: ol_shipped_quantity oe_order_lines_all.shipped_quantity%TYPE,
48: ol_flow_status_code oe_order_lines_all.flow_status_code%TYPE,
49: ol_open_flag oe_order_lines_all.open_flag%TYPE,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,
51: ol_org_id oe_order_lines_all.org_id%TYPE,
52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%TYPE,
53: ol_request_date oe_order_lines_all.request_date%TYPE,
54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_flag%TYPE,
55: ol_header_id oe_order_lines_all.header_id%TYPE,
48: ol_flow_status_code oe_order_lines_all.flow_status_code%TYPE,
49: ol_open_flag oe_order_lines_all.open_flag%TYPE,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,
51: ol_org_id oe_order_lines_all.org_id%TYPE,
52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%TYPE,
53: ol_request_date oe_order_lines_all.request_date%TYPE,
54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_flag%TYPE,
55: ol_header_id oe_order_lines_all.header_id%TYPE,
56: ol_ship_to_contact_id oe_order_lines_all.ship_to_contact_id%TYPE,
49: ol_open_flag oe_order_lines_all.open_flag%TYPE,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,
51: ol_org_id oe_order_lines_all.org_id%TYPE,
52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%TYPE,
53: ol_request_date oe_order_lines_all.request_date%TYPE,
54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_flag%TYPE,
55: ol_header_id oe_order_lines_all.header_id%TYPE,
56: ol_ship_to_contact_id oe_order_lines_all.ship_to_contact_id%TYPE,
57: ol_ship_to_org_id oe_order_lines_all.ship_to_org_id%TYPE,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,
51: ol_org_id oe_order_lines_all.org_id%TYPE,
52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%TYPE,
53: ol_request_date oe_order_lines_all.request_date%TYPE,
54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_flag%TYPE,
55: ol_header_id oe_order_lines_all.header_id%TYPE,
56: ol_ship_to_contact_id oe_order_lines_all.ship_to_contact_id%TYPE,
57: ol_ship_to_org_id oe_order_lines_all.ship_to_org_id%TYPE,
58: ol_fulfilled_quantity oe_order_lines_all.fulfilled_quantity%TYPE,
51: ol_org_id oe_order_lines_all.org_id%TYPE,
52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%TYPE,
53: ol_request_date oe_order_lines_all.request_date%TYPE,
54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_flag%TYPE,
55: ol_header_id oe_order_lines_all.header_id%TYPE,
56: ol_ship_to_contact_id oe_order_lines_all.ship_to_contact_id%TYPE,
57: ol_ship_to_org_id oe_order_lines_all.ship_to_org_id%TYPE,
58: ol_fulfilled_quantity oe_order_lines_all.fulfilled_quantity%TYPE,
59: ol_invoiced_quantity oe_order_lines_all.invoiced_quantity%TYPE,
52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%TYPE,
53: ol_request_date oe_order_lines_all.request_date%TYPE,
54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_flag%TYPE,
55: ol_header_id oe_order_lines_all.header_id%TYPE,
56: ol_ship_to_contact_id oe_order_lines_all.ship_to_contact_id%TYPE,
57: ol_ship_to_org_id oe_order_lines_all.ship_to_org_id%TYPE,
58: ol_fulfilled_quantity oe_order_lines_all.fulfilled_quantity%TYPE,
59: ol_invoiced_quantity oe_order_lines_all.invoiced_quantity%TYPE,
60: oh_order_number oe_order_headers_all.order_number%TYPE,
53: ol_request_date oe_order_lines_all.request_date%TYPE,
54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_flag%TYPE,
55: ol_header_id oe_order_lines_all.header_id%TYPE,
56: ol_ship_to_contact_id oe_order_lines_all.ship_to_contact_id%TYPE,
57: ol_ship_to_org_id oe_order_lines_all.ship_to_org_id%TYPE,
58: ol_fulfilled_quantity oe_order_lines_all.fulfilled_quantity%TYPE,
59: ol_invoiced_quantity oe_order_lines_all.invoiced_quantity%TYPE,
60: oh_order_number oe_order_headers_all.order_number%TYPE,
61: oh_ship_from_org_id oe_order_headers_all.ship_from_org_id%TYPE,
54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_flag%TYPE,
55: ol_header_id oe_order_lines_all.header_id%TYPE,
56: ol_ship_to_contact_id oe_order_lines_all.ship_to_contact_id%TYPE,
57: ol_ship_to_org_id oe_order_lines_all.ship_to_org_id%TYPE,
58: ol_fulfilled_quantity oe_order_lines_all.fulfilled_quantity%TYPE,
59: ol_invoiced_quantity oe_order_lines_all.invoiced_quantity%TYPE,
60: oh_order_number oe_order_headers_all.order_number%TYPE,
61: oh_ship_from_org_id oe_order_headers_all.ship_from_org_id%TYPE,
62: wnd_delivery_id wsh_new_deliveries.delivery_id%TYPE,
55: ol_header_id oe_order_lines_all.header_id%TYPE,
56: ol_ship_to_contact_id oe_order_lines_all.ship_to_contact_id%TYPE,
57: ol_ship_to_org_id oe_order_lines_all.ship_to_org_id%TYPE,
58: ol_fulfilled_quantity oe_order_lines_all.fulfilled_quantity%TYPE,
59: ol_invoiced_quantity oe_order_lines_all.invoiced_quantity%TYPE,
60: oh_order_number oe_order_headers_all.order_number%TYPE,
61: oh_ship_from_org_id oe_order_headers_all.ship_from_org_id%TYPE,
62: wnd_delivery_id wsh_new_deliveries.delivery_id%TYPE,
63: wnd_status_code wsh_new_deliveries.status_code%TYPE,