DBA Data[Home] [Help]

APPS.WSH_DCP_PVT dependencies on OE_ORDER_LINES_ALL

Line 41: ol_line_id oe_order_lines_all.line_id%TYPE,

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,

Line 44: ol_ordered_quantity oe_order_lines_all.ordered_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,
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,

Line 45: ol_cancelled_flag oe_order_lines_all.cancelled_flag%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,

Line 46: ol_ship_set_id oe_order_lines_all.ship_set_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,
50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%TYPE,

Line 47: ol_shipped_quantity oe_order_lines_all.shipped_quantity%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,

Line 48: ol_flow_status_code oe_order_lines_all.flow_status_code%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,

Line 49: ol_open_flag oe_order_lines_all.open_flag%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,

Line 50: ol_ship_from_org_id oe_order_lines_all.ship_from_org_id%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,

Line 51: ol_org_id oe_order_lines_all.org_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,
55: ol_header_id oe_order_lines_all.header_id%TYPE,

Line 52: ol_schedule_ship_date oe_order_lines_all.schedule_ship_date%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,

Line 53: ol_request_date oe_order_lines_all.request_date%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,

Line 54: ol_shipping_interfaced_flag oe_order_lines_all.shipping_interfaced_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,
58: ol_fulfilled_quantity oe_order_lines_all.fulfilled_quantity%TYPE,

Line 55: ol_header_id oe_order_lines_all.header_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,
59: ol_invoiced_quantity oe_order_lines_all.invoiced_quantity%TYPE,

Line 56: ol_ship_to_contact_id oe_order_lines_all.ship_to_contact_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,
60: oh_order_number oe_order_headers_all.order_number%TYPE,

Line 57: ol_ship_to_org_id oe_order_lines_all.ship_to_org_id%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,

Line 58: ol_fulfilled_quantity oe_order_lines_all.fulfilled_quantity%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,

Line 59: ol_invoiced_quantity oe_order_lines_all.invoiced_quantity%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,