VIEW: APPS.OEBV_ORDER_HEADERS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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