VIEW: APPS.ASO_I_OE_ORDER_HEADERS_V

Source

View Text - Preformatted

SELECT "HEADER_ID", "ORG_ID", "ORDER_TYPE_ID", "ORDER_NUMBER", "VERSION_NUMBER", "EXPIRATION_DATE", "ORDER_SOURCE_ID", "SOURCE_DOCUMENT_TYPE_ID", "ORIG_SYS_DOCUMENT_REF", "SOURCE_DOCUMENT_ID", "ORDERED_DATE", "REQUEST_DATE", "PRICING_DATE", "SHIPMENT_PRIORITY_CODE", "DEMAND_CLASS_CODE", "PRICE_LIST_ID", "TAX_EXEMPT_FLAG", "TAX_EXEMPT_NUMBER", "TAX_EXEMPT_REASON_CODE", "CONVERSION_RATE", "CONVERSION_TYPE_CODE", "CONVERSION_RATE_DATE", "PARTIAL_SHIPMENTS_ALLOWED", "SHIP_TOLERANCE_ABOVE", "SHIP_TOLERANCE_BELOW", "TRANSACTIONAL_CURR_CODE", "AGREEMENT_ID", "TAX_POINT_CODE", "CUST_PO_NUMBER", "INVOICING_RULE_ID", "ACCOUNTING_RULE_ID", "PAYMENT_TERM_ID", "SHIPPING_METHOD_CODE", "FREIGHT_CARRIER_CODE", "FOB_POINT_CODE", "FREIGHT_TERMS_CODE", "SOLD_TO_ORG_ID", "SOLD_FROM_ORG_ID", "SHIP_FROM_ORG_ID", "SHIP_TO_ORG_ID", "INVOICE_TO_ORG_ID", "DELIVER_TO_ORG_ID", "SOLD_TO_CONTACT_ID", "SHIP_TO_CONTACT_ID", "INVOICE_TO_CONTACT_ID", "DELIVER_TO_CONTACT_ID", "CREATION_DATE", "CREATED_BY", "LAST_UPDATED_BY", "LAST_UPDATE_DATE", "LAST_UPDATE_LOGIN", "PROGRAM_APPLICATION_ID", "PROGRAM_ID", "PROGRAM_UPDATE_DATE", "REQUEST_ID", "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", "CANCELLED_FLAG", "OPEN_FLAG", "BOOKED_FLAG", "BOOKED_DATE", "SALESREP_ID", "RETURN_REASON_CODE", "ORDER_DATE_TYPE_CODE", "EARLIEST_SCHEDULE_LIMIT", "LATEST_SCHEDULE_LIMIT", "PAYMENT_TYPE_CODE", "PAYMENT_AMOUNT", "CHECK_NUMBER", "CREDIT_CARD_CODE", "CREDIT_CARD_HOLDER_NAME", "CREDIT_CARD_NUMBER", "CREDIT_CARD_EXPIRATION_DATE", "CREDIT_CARD_APPROVAL_CODE", "SALES_CHANNEL_CODE", "FIRST_ACK_CODE", "FIRST_ACK_DATE", "LAST_ACK_CODE", "LAST_ACK_DATE", "CHANGE_SEQUENCE", "DROP_SHIP_FLAG", "CUSTOMER_PAYMENT_TERM_ID", "ORDER_CATEGORY_CODE", "SHIPPING_INSTRUCTIONS", "PACKING_INSTRUCTIONS", "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", "MARKETING_SOURCE_CODE_ID", "CREDIT_CARD_APPROVAL_DATE" FROM OE_ORDER_HEADERS

View Text - HTML Formatted

SELECT "HEADER_ID"
, "ORG_ID"
, "ORDER_TYPE_ID"
, "ORDER_NUMBER"
, "VERSION_NUMBER"
, "EXPIRATION_DATE"
, "ORDER_SOURCE_ID"
, "SOURCE_DOCUMENT_TYPE_ID"
, "ORIG_SYS_DOCUMENT_REF"
, "SOURCE_DOCUMENT_ID"
, "ORDERED_DATE"
, "REQUEST_DATE"
, "PRICING_DATE"
, "SHIPMENT_PRIORITY_CODE"
, "DEMAND_CLASS_CODE"
, "PRICE_LIST_ID"
, "TAX_EXEMPT_FLAG"
, "TAX_EXEMPT_NUMBER"
, "TAX_EXEMPT_REASON_CODE"
, "CONVERSION_RATE"
, "CONVERSION_TYPE_CODE"
, "CONVERSION_RATE_DATE"
, "PARTIAL_SHIPMENTS_ALLOWED"
, "SHIP_TOLERANCE_ABOVE"
, "SHIP_TOLERANCE_BELOW"
, "TRANSACTIONAL_CURR_CODE"
, "AGREEMENT_ID"
, "TAX_POINT_CODE"
, "CUST_PO_NUMBER"
, "INVOICING_RULE_ID"
, "ACCOUNTING_RULE_ID"
, "PAYMENT_TERM_ID"
, "SHIPPING_METHOD_CODE"
, "FREIGHT_CARRIER_CODE"
, "FOB_POINT_CODE"
, "FREIGHT_TERMS_CODE"
, "SOLD_TO_ORG_ID"
, "SOLD_FROM_ORG_ID"
, "SHIP_FROM_ORG_ID"
, "SHIP_TO_ORG_ID"
, "INVOICE_TO_ORG_ID"
, "DELIVER_TO_ORG_ID"
, "SOLD_TO_CONTACT_ID"
, "SHIP_TO_CONTACT_ID"
, "INVOICE_TO_CONTACT_ID"
, "DELIVER_TO_CONTACT_ID"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "REQUEST_ID"
, "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"
, "CANCELLED_FLAG"
, "OPEN_FLAG"
, "BOOKED_FLAG"
, "BOOKED_DATE"
, "SALESREP_ID"
, "RETURN_REASON_CODE"
, "ORDER_DATE_TYPE_CODE"
, "EARLIEST_SCHEDULE_LIMIT"
, "LATEST_SCHEDULE_LIMIT"
, "PAYMENT_TYPE_CODE"
, "PAYMENT_AMOUNT"
, "CHECK_NUMBER"
, "CREDIT_CARD_CODE"
, "CREDIT_CARD_HOLDER_NAME"
, "CREDIT_CARD_NUMBER"
, "CREDIT_CARD_EXPIRATION_DATE"
, "CREDIT_CARD_APPROVAL_CODE"
, "SALES_CHANNEL_CODE"
, "FIRST_ACK_CODE"
, "FIRST_ACK_DATE"
, "LAST_ACK_CODE"
, "LAST_ACK_DATE"
, "CHANGE_SEQUENCE"
, "DROP_SHIP_FLAG"
, "CUSTOMER_PAYMENT_TERM_ID"
, "ORDER_CATEGORY_CODE"
, "SHIPPING_INSTRUCTIONS"
, "PACKING_INSTRUCTIONS"
, "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"
, "MARKETING_SOURCE_CODE_ID"
, "CREDIT_CARD_APPROVAL_DATE"
FROM OE_ORDER_HEADERS