View: OE_AK_ORDER_HEADERS_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_AK_ORDER_HEADERS_V

View Text

SELECT /* USING THIS CONVERSION SO THAT ACCOUNTING_RULE_ID ON THE VIEW IS OF TYPE NUMBER
AND NOT NUMBER(15) AS IN OE_ORDER_HEADERS_ALL*/ TO_NUMBER(TO_CHAR(OEHDR.ACCOUNTING_RULE_ID))
, TO_NUMBER(TO_CHAR(OEHDR.ACCOUNTING_RULE_DURATION))
, OEHDR.AGREEMENT_ID
, OEHDR.ATTRIBUTE1
, OEHDR.ATTRIBUTE10
, OEHDR.ATTRIBUTE11
, OEHDR.ATTRIBUTE12
, OEHDR.ATTRIBUTE13
, OEHDR.ATTRIBUTE14
, OEHDR.ATTRIBUTE15
, OEHDR.ATTRIBUTE16
, OEHDR.ATTRIBUTE17
, OEHDR.ATTRIBUTE18
, OEHDR.ATTRIBUTE19
, OEHDR.ATTRIBUTE2
, OEHDR.ATTRIBUTE20
, OEHDR.ATTRIBUTE3
, OEHDR.ATTRIBUTE4
, OEHDR.ATTRIBUTE5
, OEHDR.ATTRIBUTE6
, OEHDR.ATTRIBUTE7
, OEHDR.ATTRIBUTE8
, OEHDR.ATTRIBUTE9
, OEHDR.BOOKED_FLAG
, OEHDR.BOOKED_DATE
, OEHDR.CANCELLED_FLAG
, OEHDR.CONTEXT
, OEHDR.CONVERSION_RATE
, OEHDR.CONVERSION_RATE_DATE
, OEHDR.CONVERSION_TYPE_CODE
, OEHDR.CREATED_BY
, OEHDR.CREATION_DATE
, OEHDR.CUST_PO_NUMBER
, OEHDR.DELIVER_TO_CONTACT_ID
, OEHDR.DELIVER_TO_ORG_ID
, OEHDR.DEMAND_CLASS_CODE
, OEHDR.EXPIRATION_DATE
, OEHDR.EARLIEST_SCHEDULE_LIMIT
, OEHDR.FOB_POINT_CODE
, OEHDR.FREIGHT_CARRIER_CODE
, OEHDR.FREIGHT_TERMS_CODE
, OEHDR.GLOBAL_ATTRIBUTE1
, OEHDR.GLOBAL_ATTRIBUTE10
, OEHDR.GLOBAL_ATTRIBUTE11
, OEHDR.GLOBAL_ATTRIBUTE12
, OEHDR.GLOBAL_ATTRIBUTE13
, OEHDR.GLOBAL_ATTRIBUTE14
, OEHDR.GLOBAL_ATTRIBUTE15
, OEHDR.GLOBAL_ATTRIBUTE16
, OEHDR.GLOBAL_ATTRIBUTE17
, OEHDR.GLOBAL_ATTRIBUTE18
, OEHDR.GLOBAL_ATTRIBUTE19
, OEHDR.GLOBAL_ATTRIBUTE2
, OEHDR.GLOBAL_ATTRIBUTE20
, OEHDR.GLOBAL_ATTRIBUTE3
, OEHDR.GLOBAL_ATTRIBUTE4
, OEHDR.GLOBAL_ATTRIBUTE5
, OEHDR.GLOBAL_ATTRIBUTE6
, OEHDR.GLOBAL_ATTRIBUTE7
, OEHDR.GLOBAL_ATTRIBUTE8
, OEHDR.GLOBAL_ATTRIBUTE9
, OEHDR.GLOBAL_ATTRIBUTE_CATEGORY
, OEHDR.HEADER_ID
, OEHDR.INVOICE_TO_CONTACT_ID
, OEHDR.INVOICE_TO_ORG_ID /*USING THIS CONVERSION SO THAT INVOICING_RULE_ID ON THE VIEW IS OF TYPE NUMBER
AND NOT NUMBER(15) AS IN OE_ORDER_HEADERS_ALL*/
, TO_NUMBER(TO_CHAR(OEHDR.INVOICING_RULE_ID))
, OEHDR.LAST_UPDATED_BY
, OEHDR.LAST_UPDATE_DATE
, OEHDR.LAST_UPDATE_LOGIN
, OEHDR.LATEST_SCHEDULE_LIMIT
, OEHDR.OPEN_FLAG
, OEHDR.ORDERED_DATE
, OEHDR.ORDER_DATE_TYPE_CODE
, OEHDR.ORDER_NUMBER
, OEHDR.ORDER_SOURCE_ID
, OEHDR.ORDER_TYPE_ID
, OEHDR.ORG_ID
, OEHDR.ORIG_SYS_DOCUMENT_REF
, OEHDR.ORDER_CATEGORY_CODE
, OEHDR.PARTIAL_SHIPMENTS_ALLOWED /*USING THIS CONVERSION SO THAT PAYMENT_TERM_ID ON THE VIEW IS OF TYPE NUMBER
AND NOT NUMBER(15) AS IN OE_ORDER_HEADERS_ALL*/
, TO_NUMBER(TO_CHAR(OEHDR.PAYMENT_TERM_ID))
, OEHDR.PRICE_LIST_ID
, OEHDR.PRICE_REQUEST_CODE
, OEHDR.PRICING_DATE
, OEHDR.PROGRAM_APPLICATION_ID
, OEHDR.PROGRAM_ID
, OEHDR.PROGRAM_UPDATE_DATE
, OEHDR.REQUEST_DATE
, OEHDR.REQUEST_ID
, OEHDR.RETURN_REASON_CODE /* USING THIS CONVERSION SO THAT SALESREP_ID ON THE VIEW IS OF TYPE NUMBER
AND NOT NUMBER(15) AS IN OE_ORDER_HEADERS_ALL*/
, TO_NUMBER(TO_CHAR(OEHDR.SALESREP_ID))
, OEHDR.SALES_CHANNEL_CODE
, OEHDR.SHIPMENT_PRIORITY_CODE
, OEHDR.SHIPPING_METHOD_CODE
, OEHDR.SHIP_FROM_ORG_ID
, OEHDR.SHIP_TOLERANCE_ABOVE
, OEHDR.SHIP_TOLERANCE_BELOW
, OEHDR.SHIP_TO_CONTACT_ID
, OEHDR.SHIP_TO_ORG_ID
, OEHDR.SOLD_FROM_ORG_ID
, OEHDR.SOLD_TO_CONTACT_ID
, OEHDR.SOLD_TO_ORG_ID
, OEHDR.SOLD_TO_PHONE_ID
, OEHDR.SOURCE_DOCUMENT_ID
, OEHDR.SOURCE_DOCUMENT_TYPE_ID
, OEHDR.TAX_EXEMPT_FLAG
, OEHDR.TAX_EXEMPT_NUMBER
, OEHDR.TAX_EXEMPT_REASON_CODE
, OEHDR.TAX_POINT_CODE
, OEHDR.TRANSACTIONAL_CURR_CODE
, OEHDR.VERSION_NUMBER
, RPAD('X'
, 1
, '-')
, RPAD('T'
, 1
, '-')
, RPAD('X'
, 30
, '-')
, RPAD('X'
, 30
, '-')
, RPAD('X'
, 32000
, '-')
, OEHDR.PAYMENT_TYPE_CODE
, OEHDR.PAYMENT_AMOUNT
, OEHDR.CHECK_NUMBER
, OEHDR.CREDIT_CARD_CODE
, OEHDR.CREDIT_CARD_HOLDER_NAME
, OEHDR.CREDIT_CARD_NUMBER
, OEHDR.CREDIT_CARD_EXPIRATION_DATE
, OEHDR.CREDIT_CARD_APPROVAL_DATE
, OEHDR.CREDIT_CARD_APPROVAL_CODE
, OEHDR.SHIPPING_INSTRUCTIONS
, OEHDR.PACKING_INSTRUCTIONS
, OEHDR.FIRST_ACK_CODE
, OEHDR.FIRST_ACK_DATE
, OEHDR.LAST_ACK_CODE
, OEHDR.LAST_ACK_DATE
, ORDTYP.DEFAULT_INBOUND_LINE_TYPE_ID
, ORDTYP.DEFAULT_OUTBOUND_LINE_TYPE_ID
, OEHDR.FLOW_STATUS_CODE
, OEHDR.CUSTOMER_PREFERENCE_SET_CODE
, OEHDR.TP_ATTRIBUTE1
, OEHDR.TP_ATTRIBUTE10
, OEHDR.TP_ATTRIBUTE11
, OEHDR.TP_ATTRIBUTE12
, OEHDR.TP_ATTRIBUTE13
, OEHDR.TP_ATTRIBUTE14
, OEHDR.TP_ATTRIBUTE15
, OEHDR.TP_ATTRIBUTE2
, OEHDR.TP_ATTRIBUTE3
, OEHDR.TP_ATTRIBUTE4
, OEHDR.TP_ATTRIBUTE5
, OEHDR.TP_ATTRIBUTE6
, OEHDR.TP_ATTRIBUTE7
, OEHDR.TP_ATTRIBUTE8
, OEHDR.TP_ATTRIBUTE9
, OEHDR.TP_CONTEXT
, OEHDR.UPGRADED_FLAG
, OEHDR.BLANKET_NUMBER
, OEHDR.DEFAULT_FULFILLMENT_SET
, OEHDR.LINE_SET_NAME
, OEHDR.FULFILLMENT_SET_NAME
, OEHDR.QUOTE_DATE
, OEHDR.QUOTE_NUMBER
, OEHDR.SALES_DOCUMENT_NAME
, OEHDR.TRANSACTION_PHASE_CODE
, OEHDR.USER_STATUS_CODE
, OEHDR.DRAFT_SUBMITTED_FLAG
, OEHDR.SOURCE_DOCUMENT_VERSION_NUMBER
, OEHDR.SOLD_TO_SITE_USE_ID
, OEHDR.SUPPLIER_SIGNATURE
, OEHDR.SUPPLIER_SIGNATURE_DATE
, OEHDR.CUSTOMER_SIGNATURE
, OEHDR.CUSTOMER_SIGNATURE_DATE
, OEHDR.END_CUSTOMER_ID
, OEHDR.END_CUSTOMER_CONTACT_ID
, OEHDR.END_CUSTOMER_SITE_USE_ID
, OEHDR.IB_OWNER
, OEHDR.IB_CURRENT_LOCATION
, OEHDR.IB_INSTALLED_AT_LOCATION
, 1
, OEHDR.ORDER_FIRMED_DATE
, PARTY.PARTY_TYPE
FROM OE_ORDER_HEADERS_ALL OEHDR
, OE_ORDER_TYPES_V ORDTYP
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY WHERE OEHDR.ORDER_TYPE_ID = ORDTYP.ORDER_TYPE_ID AND OEHDR.SOLD_TO_ORG_ID = CUST_ACCT.CUST_ACCOUNT_ID(+) AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID(+)

Columns