20: -- Catch Weight ER
21: SHIPPING_QUANTITY NUMBER,
22: SHIPPING_QUANTITY_UOM2 VARCHAR2(30),
23: SHIPPING_QUANTITY2 NUMBER,
24: FULFILLMENT_BASE oe_order_lines_all.fulfillment_base%TYPE,
25: -- Catch Weight ER
26: REQUEST_TYPE_CODE VARCHAR2(30),
27: PRICED_QUANTITY NUMBER,
28: PRICED_UOM_CODE VARCHAR2(30),
28: PRICED_UOM_CODE VARCHAR2(30),
29: CURRENCY_CODE VARCHAR2(30),
30: TRANSACTIONAL_CURR_CODE oe_order_headers_all.transactional_curr_code%TYPE,
31: ORDER_NUMBER oe_order_headers_all.order_number%TYPE,
32: LINE_CATEGORY_CODE oe_order_lines_all.line_category_code%TYPE,
33: REFERENCE_LINE_ID NUMBER,
34: UNIT_PRICE NUMBER,
35: SELLING_PRICE NUMBER,
36: PERCENT_PRICE NUMBER,
54: LINE_CATEGORY VARCHAR2(30) ,
55: SHIP_TO_ORG_ID NUMBER,
56: SOLD_TO_ORG_ID NUMBER,
57: INVOICE_TO_ORG_ID NUMBER,
58: INVOICE_INTERFACE_STATUS_CODE oe_order_lines_all.invoice_interface_status_code%TYPE,
59: FLOW_STATUS_CODE oe_order_lines_all.flow_status_code%TYPE,
60: ACTUAL_SHIPMENT_DATE oe_order_lines_all.actual_shipment_date%TYPE
61: );
62:
55: SHIP_TO_ORG_ID NUMBER,
56: SOLD_TO_ORG_ID NUMBER,
57: INVOICE_TO_ORG_ID NUMBER,
58: INVOICE_INTERFACE_STATUS_CODE oe_order_lines_all.invoice_interface_status_code%TYPE,
59: FLOW_STATUS_CODE oe_order_lines_all.flow_status_code%TYPE,
60: ACTUAL_SHIPMENT_DATE oe_order_lines_all.actual_shipment_date%TYPE
61: );
62:
63:
56: SOLD_TO_ORG_ID NUMBER,
57: INVOICE_TO_ORG_ID NUMBER,
58: INVOICE_INTERFACE_STATUS_CODE oe_order_lines_all.invoice_interface_status_code%TYPE,
59: FLOW_STATUS_CODE oe_order_lines_all.flow_status_code%TYPE,
60: ACTUAL_SHIPMENT_DATE oe_order_lines_all.actual_shipment_date%TYPE
61: );
62:
63:
64: