View: OKX_ORDER_HEADERS_V

Product:	OKX - Contracts Integration
Description:	Order header information
Implementation/DBA Data:	APPS.OKX_ORDER_HEADERS_V

View Text

SELECT OH.HEADER_ID ID1
, '#' ID2
, OH.ORDER_NUMBER NAME
, 'A' STATUS
, NULL DESCRIPTION
, SYSDATE START_DATE_ACTIVE
, NULL END_DATE_ACTIVE
, OH.ORG_ID ORG_ID
, OH.ORDER_NUMBER ORDER_NUMBER
, OH.ORDER_TYPE_ID ORDER_TYPE_ID
, OH.VERSION_NUMBER VERSION_NUMBER
, OH.CREATION_DATE CREATION_DATE
, OH.EXPIRATION_DATE EXPIRATION_DATE
, OH.ORDER_SOURCE_ID ORDER_SOURCE_ID
, OH.ORDERED_DATE ORDERED_DATE
, OH.AGREEMENT_ID AGREEMENT_ID
, OH.CUST_PO_NUMBER CUST_PO_NUMBER
, OH.PAYMENT_TERM_ID PAYMENT_TERM_ID
, OH.FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, OH.FOB_POINT_CODE FOB_POINT_CODE
, OH.FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, OH.SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, OH.INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, OH.INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, OH.CANCELLED_FLAG CANCELLED_FLAG
, OH.OPEN_FLAG OPEN_FLAG
, OH.BOOKED_FLAG BOOKED_FLAG
, OH.PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, OH.ORDER_CATEGORY_CODE ORDER_CATEGORY_CODE
, OH.SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, OH.SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, OH.REQUEST_DATE REQUEST_DATE
, OH.RETURN_REASON_CODE RETURN_REASON_CODE
, OH.PAYMENT_AMOUNT PAYMENT_AMOUNT
, OH.PRICE_LIST_ID PRICE_LIST_ID
, OH.TRANSACTIONAL_CURR_CODE TRANSACTIONAL_CURR_CODE
, OH.INVOICING_RULE_ID INVOICING_RULE_ID
, OH.ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, OH.SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, OH.SOLD_TO_CONTACT_ID SOLD_TO_CONTACT_ID
, OH.DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, OH.TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, OH.TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, OH.CONVERSION_RATE CONVERSION_RATE
, OH.CONVERSION_TYPE_CODE CONVERSION_TYPE_CODE
, OH.CONVERSION_RATE_DATE CONVERSION_RATE_DATE
, OH.SALESREP_ID SALESREP_ID
, OH.BOOKED_DATE BOOKED_DATE
, OH.PRICING_DATE PRICING_DATE
, ASO_ORDER_INT.GET_ORDER_TOTAL(OH.HEADER_ID
, NULL
, 'ALL') TOTAL_AMOUNT
, OH.FLOW_STATUS_CODE FLOW_STATUS_CODE
FROM OE_ORDER_HEADERS_ALL OH

Columns