View: OEBV_ORDER_HEADERS

Product:	ONT - Order Management
Description:	BIS View for Order Headers - required for Oracle IT
Implementation/DBA Data:	APPS.OEBV_ORDER_HEADERS

View Text

SELECT HEADER.ORDER_NUMBER
, HEADER.SOLD_TO_ORG_ID
, HEADER.ORDERED_DATE
, HEADER.CUST_PO_NUMBER
, '_LA:HEADER.SALES_CHANNEL_CODE:OE_LOOKUPS:SALES_CHANNEL:MEANING'
, HEADER.FLOW_STATUS_CODE
, '_LA:HEADER.TAX_EXEMPT_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:HEADER.TAX_EXEMPT_REASON_CODE:AR_LOOKUPS:TAX_REASON:MEANING'
, HEADER.TAX_EXEMPT_NUMBER
, HEADER.TRANSACTIONAL_CURR_CODE
, HEADER.PAYMENT_TYPE_CODE
, '_LA:HEADER.SHIPMENT_PRIORITY_CODE:OE_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, '_LA:HEADER.FREIGHT_TERMS_CODE:OE_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:HEADER.BOOKED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:HEADER.CANCELLED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, HEADER.ORG_ID
, HEADER.HEADER_ID
, HEADER.ORDER_TYPE_ID
, HEADER.SOLD_TO_CONTACT_ID
, HEADER.AGREEMENT_ID
, HEADER.PRICE_LIST_ID
, HEADER.SHIP_TO_ORG_ID
, HEADER.SHIP_TO_CONTACT_ID
, HEADER.SHIP_FROM_ORG_ID
, HEADER.INVOICING_RULE_ID
, HEADER.INVOICE_TO_ORG_ID
, HEADER.INVOICE_TO_CONTACT_ID
, HEADER.PAYMENT_TERM_ID
, HEADER.ORDER_SOURCE_ID
, HEADER.SALESREP_ID
, HEADER.LAST_UPDATE_DATE
, HEADER.LAST_UPDATED_BY
, HEADER.CREATION_DATE
, HEADER.CREATED_BY
, HEADER.END_CUSTOMER_ID
, HEADER.END_CUSTOMER_CONTACT_ID
, HEADER.END_CUSTOMER_SITE_USE_ID
, '_LA:HEADER.IB_OWNER:OE_LOOKUPS:ITEM_OWNER:MEANING'
, '_LA:HEADER.IB_CURRENT_LOCATION:OE_LOOKUPS:ITEM_CURRENT_LOCATION:MEANING'
, '_LA:HEADER.IB_INSTALLED_AT_LOCATION:OE_LOOKUPS:ITEM_INSTALL_LOCATION:MEANING'
FROM OE_ORDER_HEADERS HEADER
WHERE '_SEC:HEADER.SHIP_FROM_ORG_ID' IS NOT NULL

Columns