VIEW: APPS.OKX_ORDER_HEADERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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