VIEW: APPS.OKX_ORDER_LINES_V

Source

View Text - Preformatted

SELECT OL.LINE_ID ID1, '#' ID2, NULL NAME, NULL DESCRIPTION, NULL END_DATE_ACTIVE, SYSDATE START_DATE_ACTIVE, 'A' STATUS, OL.ORG_ID ORG_ID, OL.HEADER_ID HEADER_ID, OL.LINE_TYPE_ID LINE_TYPE_ID, OL.LINE_NUMBER LINE_NUMBER, OL.ORDERED_ITEM ORDERED_ITEM, OL.SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, OL.ORDER_QUANTITY_UOM ORDER_QUANTITY_UOM, OL.PRICING_QUANTITY PRICING_QUANTITY, OL.PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM, OL.CANCELLED_QUANTITY CANCELLED_QUANTITY, OL.SHIPPED_QUANTITY SHIPPED_QUANTITY, OL.ORDERED_QUANTITY ORDERED_QUANTITY, OL.FULFILLED_QUANTITY FULFILLED_QUANTITY, OL.SHIPPING_QUANTITY SHIPPING_QUANTITY, OL.SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM, OL.DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME, OL.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, OL.TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, OL.TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, OL.SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, OL.SHIP_TO_ORG_ID SHIP_TO_ORG_ID, OL.INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, OL.DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID, OL.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, OL.DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, OL.INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, OL.SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID, OL.SOLD_TO_ORG_ID SOLD_TO_ORG_ID, OL.CUST_PO_NUMBER CUST_PO_NUMBER, OL.SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE, OL.SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW, OL.CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER, OL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, OL.TAX_DATE TAX_DATE, OL.TAX_CODE TAX_CODE, OL.TAX_RATE TAX_RATE, OL.INVOICE_INTERFACE_STATUS_CODE INVOICE_INTERFACE_STATUS_CODE, OL.DEMAND_CLASS_CODE DEMAND_CLASS_CODE, OL.PRICE_LIST_ID PRICE_LIST_ID, OL.PRICING_DATE PRICING_DATE, OL.SHIPMENT_NUMBER SHIPMENT_NUMBER, OL.AGREEMENT_ID AGREEMENT_ID, OL.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, OL.SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, OL.FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, OL.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, OL.FOB_POINT_CODE FOB_POINT_CODE, OL.TAX_POINT_CODE TAX_POINT_CODE, OL.PAYMENT_TERM_ID PAYMENT_TERM_ID, OL.INVOICING_RULE_ID INVOICING_RULE_ID, OL.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, OL.SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID, OL.REFERENCE_LINE_ID REFERENCE_LINE_ID, OL.REFERENCE_TYPE REFERENCE_TYPE, OL.REFERENCE_HEADER_ID REFERENCE_HEADER_ID, OL.ITEM_REVISION ITEM_REVISION, OL.UNIT_SELLING_PRICE UNIT_SELLING_PRICE, OL.UNIT_LIST_PRICE UNIT_LIST_PRICE, OL.TAX_VALUE TAX_VALUE, OL.REQUEST_ID REQUEST_ID, OL.TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID, OL.LINK_TO_LINE_ID LINK_TO_LINE_ID, OL.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, OL.COMPONENT_CODE COMPONENT_CODE, OL.CONFIG_DISPLAY_SEQUENCE CONFIG_DISPLAY_SEQUENCE, OL.SORT_ORDER SORT_ORDER, OL.ITEM_TYPE_CODE ITEM_TYPE_CODE, OL.OPTION_NUMBER OPTION_NUMBER, OL.OPTION_FLAG OPTION_FLAG, OL.DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG, OL.VISIBLE_DEMAND_FLAG VISIBLE_DEMAND_FLAG, OL.LINE_CATEGORY_CODE LINE_CATEGORY_CODE, OL.ACTUAL_SHIPMENT_DATE ACTUAL_SHIPPMENT_DATE, OL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, OL.ACTUAL_ARRIVAL_DATE ACTUAL_ARRIVAL_DATE, OL.ATO_LINE_ID ATO_LINE_ID, OL.AUTO_SELECTED_QUANTITY AUTO_SELECTED_QUANTITY, OL.COMPONENT_NUMBER COMPONENT_NUMBER, OL.EARLIEST_ACCEPTABLE_DATE EARLIEST_ACCEPTABLE_DATE, OL.EXPLOSION_DATE EXPLOSION_DATE, OL.LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, OL.MODEL_GROUP_NUMBER MODEL_GROUP_NUMBER, OL.SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, OL.SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG, OL.SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE, OL.SOURCE_TYPE_CODE SOURCE_TYPE_CODE, OL.CANCELLED_FLAG CANCELLED_FLAG, OL.OPEN_FLAG OPEN_FLAG, OL.BOOKED_FLAG BOOKED_FLAG, OL.SALESREP_ID SALESREP_ID, OL.RETURN_REASON_CODE RETURN_REASON_CODE, OL.ARRIVAL_SET_ID ARRIVAL_SET_ID, OL.SHIP_SET_ID SHIP_SET_ID, OL.SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID, OL.CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM, OL.AUTHORIZED_TO_SHIP_FLAG AUTHORIZED_TO_SHIP_FLAG, OL.OVER_SHIP_REASON_CODE OVER_SHIP_REASON_CODE, OL.OVER_SHIP_RESOLVED_FLAG OVER_SHIP_RESOLVED_FLAG, OL.ORDERED_ITEM_ID ORDERED_ITEM_ID, OL.ITEM_IDENTIFIER_TYPE ITEM_IDENTIFIER_TYPE, OL.CONFIGURATION_ID CONFIGURATION_ID, OL.COMMITMENT_ID COMMITMENT_ID, OL.SHIPPING_INTERFACED_FLAG SHIPPING_INTERFACED_FLAG, OL.CREDIT_INVOICE_LINE_ID CREDIT_INVOICE_LINE_ID, OL.ORDER_SOURCE_ID ORDER_SOURCE_ID, OL.ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF, OL.DROP_SHIP_FLAG DROP_SHIP_FLAG, OL.CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER, OL.CUSTOMER_SHIPMENT_NUMBER CUSTOMER_SHIPMENT_NUMBER, OL.CUSTOMER_ITEM_NET_PRICE CUSTOMER_ITEM_NET_PRICE, OL.OVER_SHIP_REASON_CODE SHIP_REASON_CODE, OL.CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID, OL.FULFILLED_FLAG FULFILLED_FLAG, OL.END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, OL.CONFIG_HEADER_ID CONFIG_HEADER_ID, OL.CONFIG_REV_NBR CONFIG_REV_NBR, OL.MFG_COMPONENT_SEQUENCE_ID MFG_COMPONENT_SEQUENCE_ID, OL.INVOICED_QUANTITY INVOICED_QUANTITY, OL.REFERENCE_CUSTOMER_TRX_LINE_ID REFERENCE_CUSTOMER_TRX_LINE_ID, OL.SPLIT_BY SPLIT_BY, OL.LINE_SET_ID LINE_SET_ID, OL.SERVICE_TXN_REASON_CODE SERVICE_TXN_REASON_CODE, OL.SERVICE_TXN_COMMENTS SERVICE_TXN_COMMENT, OL.SERVICE_DURATION SERVICE_DURATION, OL.SERVICE_START_DATE SERVICE_START_DATE, OL.SERVICE_END_DATE SERVICE_END_DATE, OL.SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG, OL.UNIT_LIST_PERCENT UNIT_LIST_PERCENT, OL.UNIT_SELLING_PERCENT UNIT_SELLING_PERCENT, OL.UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE, OL.SERVICE_NUMBER SERVICE_NUMBER, OL.SERVICE_PERIOD SERVICE_PERIOD, OL.SHIPPABLE_FLAG SHIPPABLE_FLAG, OL.MODEL_REMNANT_FLAG MODEL_REMNANT_FLAG, OL.FULFILLMENT_METHOD_CODE FULFILLMENT_METHOD_CODE, OL.MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID, OL.SERVICE_REFERENCE_TYPE_CODE SERVICE_REFERENCE_TYPE_CODE, OL.SERVICE_REFERENCE_LINE_ID SERVICE_REFERENCE_LINE_ID, OL.SERVICE_REFERENCE_SYSTEM_ID SERVICE_REFERENCE_SYSTEM_ID, OL.CALCULATE_PRICE_FLAG CALCULATE_PRICE_FLAG, OL.REVENUE_AMOUNT REVENUE_AMOUNT, OL.FULFILLMENT_DATE FULFILLMENT_DATE, ASO_ORDER_INT.GET_ORDER_TOTAL(OL.HEADER_ID,OL.LINE_ID,'ALL') TOTAL_AMOUNT, OL.FLOW_STATUS_CODE FLOW_STATUS_CODE FROM OE_ORDER_LINES_ALL OL

View Text - HTML Formatted

SELECT OL.LINE_ID ID1
, '#' ID2
, NULL NAME
, NULL DESCRIPTION
, NULL END_DATE_ACTIVE
, SYSDATE START_DATE_ACTIVE
, 'A' STATUS
, OL.ORG_ID ORG_ID
, OL.HEADER_ID HEADER_ID
, OL.LINE_TYPE_ID LINE_TYPE_ID
, OL.LINE_NUMBER LINE_NUMBER
, OL.ORDERED_ITEM ORDERED_ITEM
, OL.SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, OL.ORDER_QUANTITY_UOM ORDER_QUANTITY_UOM
, OL.PRICING_QUANTITY PRICING_QUANTITY
, OL.PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM
, OL.CANCELLED_QUANTITY CANCELLED_QUANTITY
, OL.SHIPPED_QUANTITY SHIPPED_QUANTITY
, OL.ORDERED_QUANTITY ORDERED_QUANTITY
, OL.FULFILLED_QUANTITY FULFILLED_QUANTITY
, OL.SHIPPING_QUANTITY SHIPPING_QUANTITY
, OL.SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM
, OL.DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME
, OL.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, OL.TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, OL.TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, OL.SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, OL.SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, OL.INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, OL.DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID
, OL.SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, OL.DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, OL.INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, OL.SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID
, OL.SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, OL.CUST_PO_NUMBER CUST_PO_NUMBER
, OL.SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE
, OL.SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW
, OL.CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER
, OL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, OL.TAX_DATE TAX_DATE
, OL.TAX_CODE TAX_CODE
, OL.TAX_RATE TAX_RATE
, OL.INVOICE_INTERFACE_STATUS_CODE INVOICE_INTERFACE_STATUS_CODE
, OL.DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, OL.PRICE_LIST_ID PRICE_LIST_ID
, OL.PRICING_DATE PRICING_DATE
, OL.SHIPMENT_NUMBER SHIPMENT_NUMBER
, OL.AGREEMENT_ID AGREEMENT_ID
, OL.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, OL.SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, OL.FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, OL.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, OL.FOB_POINT_CODE FOB_POINT_CODE
, OL.TAX_POINT_CODE TAX_POINT_CODE
, OL.PAYMENT_TERM_ID PAYMENT_TERM_ID
, OL.INVOICING_RULE_ID INVOICING_RULE_ID
, OL.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, OL.SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID
, OL.REFERENCE_LINE_ID REFERENCE_LINE_ID
, OL.REFERENCE_TYPE REFERENCE_TYPE
, OL.REFERENCE_HEADER_ID REFERENCE_HEADER_ID
, OL.ITEM_REVISION ITEM_REVISION
, OL.UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, OL.UNIT_LIST_PRICE UNIT_LIST_PRICE
, OL.TAX_VALUE TAX_VALUE
, OL.REQUEST_ID REQUEST_ID
, OL.TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, OL.LINK_TO_LINE_ID LINK_TO_LINE_ID
, OL.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, OL.COMPONENT_CODE COMPONENT_CODE
, OL.CONFIG_DISPLAY_SEQUENCE CONFIG_DISPLAY_SEQUENCE
, OL.SORT_ORDER SORT_ORDER
, OL.ITEM_TYPE_CODE ITEM_TYPE_CODE
, OL.OPTION_NUMBER OPTION_NUMBER
, OL.OPTION_FLAG OPTION_FLAG
, OL.DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG
, OL.VISIBLE_DEMAND_FLAG VISIBLE_DEMAND_FLAG
, OL.LINE_CATEGORY_CODE LINE_CATEGORY_CODE
, OL.ACTUAL_SHIPMENT_DATE ACTUAL_SHIPPMENT_DATE
, OL.CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, OL.ACTUAL_ARRIVAL_DATE ACTUAL_ARRIVAL_DATE
, OL.ATO_LINE_ID ATO_LINE_ID
, OL.AUTO_SELECTED_QUANTITY AUTO_SELECTED_QUANTITY
, OL.COMPONENT_NUMBER COMPONENT_NUMBER
, OL.EARLIEST_ACCEPTABLE_DATE EARLIEST_ACCEPTABLE_DATE
, OL.EXPLOSION_DATE EXPLOSION_DATE
, OL.LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, OL.MODEL_GROUP_NUMBER MODEL_GROUP_NUMBER
, OL.SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, OL.SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, OL.SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE
, OL.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, OL.CANCELLED_FLAG CANCELLED_FLAG
, OL.OPEN_FLAG OPEN_FLAG
, OL.BOOKED_FLAG BOOKED_FLAG
, OL.SALESREP_ID SALESREP_ID
, OL.RETURN_REASON_CODE RETURN_REASON_CODE
, OL.ARRIVAL_SET_ID ARRIVAL_SET_ID
, OL.SHIP_SET_ID SHIP_SET_ID
, OL.SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID
, OL.CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM
, OL.AUTHORIZED_TO_SHIP_FLAG AUTHORIZED_TO_SHIP_FLAG
, OL.OVER_SHIP_REASON_CODE OVER_SHIP_REASON_CODE
, OL.OVER_SHIP_RESOLVED_FLAG OVER_SHIP_RESOLVED_FLAG
, OL.ORDERED_ITEM_ID ORDERED_ITEM_ID
, OL.ITEM_IDENTIFIER_TYPE ITEM_IDENTIFIER_TYPE
, OL.CONFIGURATION_ID CONFIGURATION_ID
, OL.COMMITMENT_ID COMMITMENT_ID
, OL.SHIPPING_INTERFACED_FLAG SHIPPING_INTERFACED_FLAG
, OL.CREDIT_INVOICE_LINE_ID CREDIT_INVOICE_LINE_ID
, OL.ORDER_SOURCE_ID ORDER_SOURCE_ID
, OL.ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
, OL.DROP_SHIP_FLAG DROP_SHIP_FLAG
, OL.CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER
, OL.CUSTOMER_SHIPMENT_NUMBER CUSTOMER_SHIPMENT_NUMBER
, OL.CUSTOMER_ITEM_NET_PRICE CUSTOMER_ITEM_NET_PRICE
, OL.OVER_SHIP_REASON_CODE SHIP_REASON_CODE
, OL.CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID
, OL.FULFILLED_FLAG FULFILLED_FLAG
, OL.END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, OL.CONFIG_HEADER_ID CONFIG_HEADER_ID
, OL.CONFIG_REV_NBR CONFIG_REV_NBR
, OL.MFG_COMPONENT_SEQUENCE_ID MFG_COMPONENT_SEQUENCE_ID
, OL.INVOICED_QUANTITY INVOICED_QUANTITY
, OL.REFERENCE_CUSTOMER_TRX_LINE_ID REFERENCE_CUSTOMER_TRX_LINE_ID
, OL.SPLIT_BY SPLIT_BY
, OL.LINE_SET_ID LINE_SET_ID
, OL.SERVICE_TXN_REASON_CODE SERVICE_TXN_REASON_CODE
, OL.SERVICE_TXN_COMMENTS SERVICE_TXN_COMMENT
, OL.SERVICE_DURATION SERVICE_DURATION
, OL.SERVICE_START_DATE SERVICE_START_DATE
, OL.SERVICE_END_DATE SERVICE_END_DATE
, OL.SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG
, OL.UNIT_LIST_PERCENT UNIT_LIST_PERCENT
, OL.UNIT_SELLING_PERCENT UNIT_SELLING_PERCENT
, OL.UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE
, OL.SERVICE_NUMBER SERVICE_NUMBER
, OL.SERVICE_PERIOD SERVICE_PERIOD
, OL.SHIPPABLE_FLAG SHIPPABLE_FLAG
, OL.MODEL_REMNANT_FLAG MODEL_REMNANT_FLAG
, OL.FULFILLMENT_METHOD_CODE FULFILLMENT_METHOD_CODE
, OL.MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID
, OL.SERVICE_REFERENCE_TYPE_CODE SERVICE_REFERENCE_TYPE_CODE
, OL.SERVICE_REFERENCE_LINE_ID SERVICE_REFERENCE_LINE_ID
, OL.SERVICE_REFERENCE_SYSTEM_ID SERVICE_REFERENCE_SYSTEM_ID
, OL.CALCULATE_PRICE_FLAG CALCULATE_PRICE_FLAG
, OL.REVENUE_AMOUNT REVENUE_AMOUNT
, OL.FULFILLMENT_DATE FULFILLMENT_DATE
, ASO_ORDER_INT.GET_ORDER_TOTAL(OL.HEADER_ID
, OL.LINE_ID
, 'ALL') TOTAL_AMOUNT
, OL.FLOW_STATUS_CODE FLOW_STATUS_CODE
FROM OE_ORDER_LINES_ALL OL