VIEW: APPS.ASO_I_OE_ORDER_LINES_V

Source

View Text - Preformatted

SELECT LINE_ID ,ORG_ID ,HEADER_ID ,LINE_TYPE_ID ,LINE_NUMBER ,REQUEST_DATE ,PROMISE_DATE ,SCHEDULE_SHIP_DATE ,ORDER_QUANTITY_UOM ,PRICING_QUANTITY ,PRICING_QUANTITY_UOM ,CANCELLED_QUANTITY ,SHIPPED_QUANTITY ,ORDERED_QUANTITY ,FULFILLED_QUANTITY ,SHIPPING_QUANTITY ,SHIPPING_QUANTITY_UOM ,DELIVERY_LEAD_TIME ,TAX_EXEMPT_FLAG ,TAX_EXEMPT_NUMBER ,TAX_EXEMPT_REASON_CODE ,SHIP_FROM_ORG_ID ,SHIP_TO_ORG_ID ,INVOICE_TO_ORG_ID ,DELIVER_TO_ORG_ID ,SHIP_TO_CONTACT_ID ,DELIVER_TO_CONTACT_ID ,INVOICE_TO_CONTACT_ID ,SOLD_TO_ORG_ID ,SOLD_FROM_ORG_ID ,CUST_PO_NUMBER ,SHIP_TOLERANCE_ABOVE ,SHIP_TOLERANCE_BELOW ,DEMAND_BUCKET_TYPE_CODE ,VEH_CUS_ITEM_CUM_KEY_ID ,RLA_SCHEDULE_TYPE_CODE ,CUSTOMER_DOCK_CODE ,CUSTOMER_JOB ,CUSTOMER_PRODUCTION_LINE ,CUST_MODEL_SERIAL_NUMBER ,PROJECT_ID ,TASK_ID ,INVENTORY_ITEM_ID ,TAX_DATE ,TAX_CODE ,TAX_RATE ,DEMAND_CLASS_CODE ,PRICE_LIST_ID ,PRICING_DATE ,SHIPMENT_NUMBER ,AGREEMENT_ID ,SHIPMENT_PRIORITY_CODE ,SHIPPING_METHOD_CODE ,FREIGHT_CARRIER_CODE ,FREIGHT_TERMS_CODE ,FOB_POINT_CODE ,TAX_POINT_CODE ,PAYMENT_TERM_ID ,INVOICING_RULE_ID ,ACCOUNTING_RULE_ID ,SOURCE_DOCUMENT_TYPE_ID ,ORIG_SYS_DOCUMENT_REF ,SOURCE_DOCUMENT_ID ,ORIG_SYS_LINE_REF ,SOURCE_DOCUMENT_LINE_ID ,REFERENCE_LINE_ID ,REFERENCE_TYPE ,REFERENCE_HEADER_ID ,ITEM_REVISION ,UNIT_SELLING_PRICE ,UNIT_LIST_PRICE ,TAX_VALUE ,CONTEXT ,ATTRIBUTE1 ,ATTRIBUTE2 ,ATTRIBUTE3 ,ATTRIBUTE4 ,ATTRIBUTE5 ,ATTRIBUTE6 ,ATTRIBUTE7 ,ATTRIBUTE8 ,ATTRIBUTE9 ,ATTRIBUTE10 ,ATTRIBUTE11 ,ATTRIBUTE12 ,ATTRIBUTE13 ,ATTRIBUTE14 ,ATTRIBUTE15 ,GLOBAL_ATTRIBUTE_CATEGORY ,GLOBAL_ATTRIBUTE1 ,GLOBAL_ATTRIBUTE2 ,GLOBAL_ATTRIBUTE3 ,GLOBAL_ATTRIBUTE4 ,GLOBAL_ATTRIBUTE5 ,GLOBAL_ATTRIBUTE6 ,GLOBAL_ATTRIBUTE7 ,GLOBAL_ATTRIBUTE8 ,GLOBAL_ATTRIBUTE9 ,GLOBAL_ATTRIBUTE10 ,GLOBAL_ATTRIBUTE11 ,GLOBAL_ATTRIBUTE12 ,GLOBAL_ATTRIBUTE13 ,GLOBAL_ATTRIBUTE14 ,GLOBAL_ATTRIBUTE15 ,GLOBAL_ATTRIBUTE16 ,GLOBAL_ATTRIBUTE17 ,GLOBAL_ATTRIBUTE18 ,GLOBAL_ATTRIBUTE19 ,GLOBAL_ATTRIBUTE20 ,PRICING_CONTEXT ,PRICING_ATTRIBUTE1 ,PRICING_ATTRIBUTE2 ,PRICING_ATTRIBUTE3 ,PRICING_ATTRIBUTE4 ,PRICING_ATTRIBUTE5 ,PRICING_ATTRIBUTE6 ,PRICING_ATTRIBUTE7 ,PRICING_ATTRIBUTE8 ,PRICING_ATTRIBUTE9 ,PRICING_ATTRIBUTE10 ,INDUSTRY_CONTEXT ,INDUSTRY_ATTRIBUTE1 ,INDUSTRY_ATTRIBUTE2 ,INDUSTRY_ATTRIBUTE3 ,INDUSTRY_ATTRIBUTE4 ,INDUSTRY_ATTRIBUTE5 ,INDUSTRY_ATTRIBUTE6 ,INDUSTRY_ATTRIBUTE7 ,INDUSTRY_ATTRIBUTE8 ,INDUSTRY_ATTRIBUTE9 ,INDUSTRY_ATTRIBUTE10 ,INDUSTRY_ATTRIBUTE11 ,INDUSTRY_ATTRIBUTE13 ,INDUSTRY_ATTRIBUTE12 ,INDUSTRY_ATTRIBUTE14 ,INDUSTRY_ATTRIBUTE15 ,INDUSTRY_ATTRIBUTE16 ,INDUSTRY_ATTRIBUTE17 ,INDUSTRY_ATTRIBUTE18 ,INDUSTRY_ATTRIBUTE19 ,INDUSTRY_ATTRIBUTE20 ,INDUSTRY_ATTRIBUTE21 ,INDUSTRY_ATTRIBUTE22 ,INDUSTRY_ATTRIBUTE23 ,INDUSTRY_ATTRIBUTE24 ,INDUSTRY_ATTRIBUTE25 ,INDUSTRY_ATTRIBUTE26 ,INDUSTRY_ATTRIBUTE27 ,INDUSTRY_ATTRIBUTE28 ,INDUSTRY_ATTRIBUTE29 ,INDUSTRY_ATTRIBUTE30 ,CREATION_DATE ,CREATED_BY ,LAST_UPDATE_DATE ,LAST_UPDATED_BY ,LAST_UPDATE_LOGIN ,PROGRAM_APPLICATION_ID ,PROGRAM_ID ,PROGRAM_UPDATE_DATE ,REQUEST_ID ,CONFIGURATION_ID ,LINK_TO_LINE_ID ,COMPONENT_SEQUENCE_ID ,COMPONENT_CODE ,CONFIG_DISPLAY_SEQUENCE ,SORT_ORDER ,ITEM_TYPE_CODE ,OPTION_NUMBER ,OPTION_FLAG ,DEP_PLAN_REQUIRED_FLAG ,VISIBLE_DEMAND_FLAG ,LINE_CATEGORY_CODE ,ACTUAL_SHIPMENT_DATE ,CUSTOMER_TRX_LINE_ID ,RETURN_CONTEXT ,RETURN_ATTRIBUTE1 ,RETURN_ATTRIBUTE2 ,RETURN_ATTRIBUTE3 ,RETURN_ATTRIBUTE4 ,RETURN_ATTRIBUTE5 ,RETURN_ATTRIBUTE6 ,RETURN_ATTRIBUTE7 ,RETURN_ATTRIBUTE8 ,RETURN_ATTRIBUTE9 ,RETURN_ATTRIBUTE10 ,RETURN_ATTRIBUTE11 ,RETURN_ATTRIBUTE12 ,RETURN_ATTRIBUTE13 ,RETURN_ATTRIBUTE14 ,RETURN_ATTRIBUTE15 ,INTMED_SHIP_TO_ORG_ID ,INTMED_SHIP_TO_CONTACT_ID ,ACTUAL_ARRIVAL_DATE ,ATO_LINE_ID ,AUTO_SELECTED_QUANTITY ,COMPONENT_NUMBER ,EARLIEST_ACCEPTABLE_DATE ,EXPLOSION_DATE ,LATEST_ACCEPTABLE_DATE ,MODEL_GROUP_NUMBER ,SCHEDULE_ARRIVAL_DATE ,SHIP_MODEL_COMPLETE_FLAG ,SCHEDULE_STATUS_CODE ,SOURCE_TYPE_CODE ,TOP_MODEL_LINE_ID ,BOOKED_FLAG ,CANCELLED_FLAG ,OPEN_FLAG ,SALESREP_ID ,RETURN_REASON_CODE ,ARRIVAL_SET_ID ,SHIP_SET_ID ,SPLIT_FROM_LINE_ID ,CUST_PRODUCTION_SEQ_NUM ,AUTHORIZED_TO_SHIP_FLAG ,OVER_SHIP_REASON_CODE ,OVER_SHIP_RESOLVED_FLAG ,ITEM_IDENTIFIER_TYPE ,SHIPPING_INTERFACED_FLAG ,CREDIT_INVOICE_LINE_ID ,FULFILLED_FLAG ,END_ITEM_UNIT_NUMBER ,COMMITMENT_ID ,FIRST_ACK_CODE ,FIRST_ACK_DATE ,LAST_ACK_CODE ,LAST_ACK_DATE ,ORDER_SOURCE_ID ,ORIG_SYS_SHIPMENT_REF ,CHANGE_SEQUENCE ,DROP_SHIP_FLAG ,CUSTOMER_LINE_NUMBER ,CUSTOMER_SHIPMENT_NUMBER ,CUSTOMER_ITEM_NET_PRICE ,CUSTOMER_PAYMENT_TERM_ID ,PLANNING_PRIORITY ,CONFIG_HEADER_ID ,CONFIG_REV_NBR ,MFG_COMPONENT_SEQUENCE_ID ,SHIPPING_INSTRUCTIONS ,PACKING_INSTRUCTIONS ,INVOICED_QUANTITY ,REFERENCE_CUSTOMER_TRX_LINE_ID ,SPLIT_BY ,LINE_SET_ID ,SERVICE_TXN_REASON_CODE ,SERVICE_DURATION ,SERVICE_START_DATE ,SERVICE_END_DATE ,SERVICE_COTERMINATE_FLAG ,SERVICE_TXN_COMMENTS ,UNIT_SELLING_PERCENT ,UNIT_LIST_PERCENT ,UNIT_PERCENT_BASE_PRICE ,SERVICE_NUMBER ,SERVICE_PERIOD ,SHIPPABLE_FLAG ,MODEL_REMNANT_FLAG ,RE_SOURCE_FLAG ,FLOW_STATUS_CODE ,TP_CONTEXT ,TP_ATTRIBUTE1 ,TP_ATTRIBUTE2 ,TP_ATTRIBUTE3 ,TP_ATTRIBUTE4 ,TP_ATTRIBUTE5 ,TP_ATTRIBUTE6 ,TP_ATTRIBUTE7 ,TP_ATTRIBUTE8 ,TP_ATTRIBUTE9 ,TP_ATTRIBUTE10 ,TP_ATTRIBUTE11 ,TP_ATTRIBUTE12 ,TP_ATTRIBUTE13 ,TP_ATTRIBUTE14 ,TP_ATTRIBUTE15 ,FULFILLMENT_METHOD_CODE ,SERVICE_REFERENCE_TYPE_CODE ,SERVICE_REFERENCE_LINE_ID ,SERVICE_REFERENCE_SYSTEM_ID ,INVOICE_INTERFACE_STATUS_CODE ,ORDERED_ITEM ,ORDERED_ITEM_ID ,CALCULATE_PRICE_FLAG ,MARKETING_SOURCE_CODE_ID ,REVENUE_AMOUNT ,FULFILLMENT_DATE FROM OE_ORDER_LINES

View Text - HTML Formatted

SELECT LINE_ID
, ORG_ID
, HEADER_ID
, LINE_TYPE_ID
, LINE_NUMBER
, REQUEST_DATE
, PROMISE_DATE
, SCHEDULE_SHIP_DATE
, ORDER_QUANTITY_UOM
, PRICING_QUANTITY
, PRICING_QUANTITY_UOM
, CANCELLED_QUANTITY
, SHIPPED_QUANTITY
, ORDERED_QUANTITY
, FULFILLED_QUANTITY
, SHIPPING_QUANTITY
, SHIPPING_QUANTITY_UOM
, DELIVERY_LEAD_TIME
, TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE
, SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID
, INVOICE_TO_ORG_ID
, DELIVER_TO_ORG_ID
, SHIP_TO_CONTACT_ID
, DELIVER_TO_CONTACT_ID
, INVOICE_TO_CONTACT_ID
, SOLD_TO_ORG_ID
, SOLD_FROM_ORG_ID
, CUST_PO_NUMBER
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, DEMAND_BUCKET_TYPE_CODE
, VEH_CUS_ITEM_CUM_KEY_ID
, RLA_SCHEDULE_TYPE_CODE
, CUSTOMER_DOCK_CODE
, CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE
, CUST_MODEL_SERIAL_NUMBER
, PROJECT_ID
, TASK_ID
, INVENTORY_ITEM_ID
, TAX_DATE
, TAX_CODE
, TAX_RATE
, DEMAND_CLASS_CODE
, PRICE_LIST_ID
, PRICING_DATE
, SHIPMENT_NUMBER
, AGREEMENT_ID
, SHIPMENT_PRIORITY_CODE
, SHIPPING_METHOD_CODE
, FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE
, FOB_POINT_CODE
, TAX_POINT_CODE
, PAYMENT_TERM_ID
, INVOICING_RULE_ID
, ACCOUNTING_RULE_ID
, SOURCE_DOCUMENT_TYPE_ID
, ORIG_SYS_DOCUMENT_REF
, SOURCE_DOCUMENT_ID
, ORIG_SYS_LINE_REF
, SOURCE_DOCUMENT_LINE_ID
, REFERENCE_LINE_ID
, REFERENCE_TYPE
, REFERENCE_HEADER_ID
, ITEM_REVISION
, UNIT_SELLING_PRICE
, UNIT_LIST_PRICE
, TAX_VALUE
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20
, PRICING_CONTEXT
, PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10
, INDUSTRY_CONTEXT
, INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, CONFIGURATION_ID
, LINK_TO_LINE_ID
, COMPONENT_SEQUENCE_ID
, COMPONENT_CODE
, CONFIG_DISPLAY_SEQUENCE
, SORT_ORDER
, ITEM_TYPE_CODE
, OPTION_NUMBER
, OPTION_FLAG
, DEP_PLAN_REQUIRED_FLAG
, VISIBLE_DEMAND_FLAG
, LINE_CATEGORY_CODE
, ACTUAL_SHIPMENT_DATE
, CUSTOMER_TRX_LINE_ID
, RETURN_CONTEXT
, RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9
, RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15
, INTMED_SHIP_TO_ORG_ID
, INTMED_SHIP_TO_CONTACT_ID
, ACTUAL_ARRIVAL_DATE
, ATO_LINE_ID
, AUTO_SELECTED_QUANTITY
, COMPONENT_NUMBER
, EARLIEST_ACCEPTABLE_DATE
, EXPLOSION_DATE
, LATEST_ACCEPTABLE_DATE
, MODEL_GROUP_NUMBER
, SCHEDULE_ARRIVAL_DATE
, SHIP_MODEL_COMPLETE_FLAG
, SCHEDULE_STATUS_CODE
, SOURCE_TYPE_CODE
, TOP_MODEL_LINE_ID
, BOOKED_FLAG
, CANCELLED_FLAG
, OPEN_FLAG
, SALESREP_ID
, RETURN_REASON_CODE
, ARRIVAL_SET_ID
, SHIP_SET_ID
, SPLIT_FROM_LINE_ID
, CUST_PRODUCTION_SEQ_NUM
, AUTHORIZED_TO_SHIP_FLAG
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, ITEM_IDENTIFIER_TYPE
, SHIPPING_INTERFACED_FLAG
, CREDIT_INVOICE_LINE_ID
, FULFILLED_FLAG
, END_ITEM_UNIT_NUMBER
, COMMITMENT_ID
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, LAST_ACK_CODE
, LAST_ACK_DATE
, ORDER_SOURCE_ID
, ORIG_SYS_SHIPMENT_REF
, CHANGE_SEQUENCE
, DROP_SHIP_FLAG
, CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_NET_PRICE
, CUSTOMER_PAYMENT_TERM_ID
, PLANNING_PRIORITY
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, MFG_COMPONENT_SEQUENCE_ID
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, INVOICED_QUANTITY
, REFERENCE_CUSTOMER_TRX_LINE_ID
, SPLIT_BY
, LINE_SET_ID
, SERVICE_TXN_REASON_CODE
, SERVICE_DURATION
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, SERVICE_TXN_COMMENTS
, UNIT_SELLING_PERCENT
, UNIT_LIST_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_PERIOD
, SHIPPABLE_FLAG
, MODEL_REMNANT_FLAG
, RE_SOURCE_FLAG
, FLOW_STATUS_CODE
, TP_CONTEXT
, TP_ATTRIBUTE1
, TP_ATTRIBUTE2
, TP_ATTRIBUTE3
, TP_ATTRIBUTE4
, TP_ATTRIBUTE5
, TP_ATTRIBUTE6
, TP_ATTRIBUTE7
, TP_ATTRIBUTE8
, TP_ATTRIBUTE9
, TP_ATTRIBUTE10
, TP_ATTRIBUTE11
, TP_ATTRIBUTE12
, TP_ATTRIBUTE13
, TP_ATTRIBUTE14
, TP_ATTRIBUTE15
, FULFILLMENT_METHOD_CODE
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, INVOICE_INTERFACE_STATUS_CODE
, ORDERED_ITEM
, ORDERED_ITEM_ID
, CALCULATE_PRICE_FLAG
, MARKETING_SOURCE_CODE_ID
, REVENUE_AMOUNT
, FULFILLMENT_DATE
FROM OE_ORDER_LINES