VIEW: APPS.OE_CRM_ORDER_LINES_V

Source

View Text - Preformatted

SELECT LINE_ID, ORG_ID, HEADER_ID, LINE_TYPE_ID, LINE_NUMBER, ORDERED_ITEM, 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, CUST_PO_NUMBER, SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW, DEMAND_BUCKET_TYPE_CODE, 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, INVOICE_INTERFACE_STATUS_CODE, SPLIT_FROM_LINE_ID, CUST_PRODUCTION_SEQ_NUM, AUTHORIZED_TO_SHIP_FLAG, VEH_CUS_ITEM_CUM_KEY_ID, OVER_SHIP_REASON_CODE, OVER_SHIP_RESOLVED_FLAG, ITEM_IDENTIFIER_TYPE, COMMITMENT_ID, SHIPPING_INTERFACED_FLAG, CREDIT_INVOICE_LINE_ID, FIRST_ACK_CODE, FIRST_ACK_DATE, LAST_ACK_CODE, LAST_ACK_DATE, PLANNING_PRIORITY, CONFIG_HEADER_ID, CONFIG_REV_NBR, SOLD_FROM_ORG_ID, FULFILLED_FLAG, END_ITEM_UNIT_NUMBER, SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS, INVOICED_QUANTITY, REFERENCE_CUSTOMER_TRX_LINE_ID, SERVICE_TXN_REASON_CODE, SERVICE_TXN_COMMENTS, SERVICE_DURATION, SERVICE_START_DATE, SERVICE_END_DATE, SERVICE_COTERMINATE_FLAG, UNIT_LIST_PERCENT, UNIT_SELLING_PERCENT, UNIT_PERCENT_BASE_PRICE, SERVICE_NUMBER, SERVICE_REFERENCE_TYPE_CODE, SERVICE_REFERENCE_LINE_ID, SERVICE_REFERENCE_SYSTEM_ID, MARKETING_SOURCE_CODE_ID, FLOW_STATUS_CODE, MODEL_REMNANT_FLAG, FULFILLMENT_METHOD_CODE, ORDERED_ITEM_ID from OE_ORDER_LINES

View Text - HTML Formatted

SELECT LINE_ID
, ORG_ID
, HEADER_ID
, LINE_TYPE_ID
, LINE_NUMBER
, ORDERED_ITEM
, 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
, CUST_PO_NUMBER
, SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW
, DEMAND_BUCKET_TYPE_CODE
, 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
, INVOICE_INTERFACE_STATUS_CODE
, SPLIT_FROM_LINE_ID
, CUST_PRODUCTION_SEQ_NUM
, AUTHORIZED_TO_SHIP_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, ITEM_IDENTIFIER_TYPE
, COMMITMENT_ID
, SHIPPING_INTERFACED_FLAG
, CREDIT_INVOICE_LINE_ID
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, LAST_ACK_CODE
, LAST_ACK_DATE
, PLANNING_PRIORITY
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, SOLD_FROM_ORG_ID
, FULFILLED_FLAG
, END_ITEM_UNIT_NUMBER
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, INVOICED_QUANTITY
, REFERENCE_CUSTOMER_TRX_LINE_ID
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, MARKETING_SOURCE_CODE_ID
, FLOW_STATUS_CODE
, MODEL_REMNANT_FLAG
, FULFILLMENT_METHOD_CODE
, ORDERED_ITEM_ID
FROM OE_ORDER_LINES