View: OEFV_SALES_ORDERS

View Text

SELECT HEADER.ORDER_NUMBER
, ORDER_TYPE.NAME
, '_LA:HEADER.SHIP_PARTIAL_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, HEADER.SHIPPING_INSTRUCTIONS
, HEADER.PACKING_INSTRUCTIONS
, '_LA:HEADER.SALES_CHANNEL_CODE:SO_LOOKUPS:SALES_CHANNEL:MEANING'
, GCT.USER_CONVERSION_TYPE
, HEADER.CONVERSION_RATE
, HEADER.CONVERSION_DATE
, '_LA:HEADER.TAX_EXEMPT_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, HEADER.TAX_EXEMPT_NUM
, '_LA:HEADER.TAX_EXEMPT_REASON_CODE:AR_LOOKUPS:TAX_REASON:MEANING'
, '_LA:HEADER.ORDER_CATEGORY:SO_LOOKUPS:ORDER_CATEGORY:MEANING'
, HEADER.ORIGINAL_SYSTEM_REFERENCE
, HEADER.DATE_ORDERED
, HEADER.DATE_REQUESTED_CURRENT
, '_LA:HEADER.OPEN_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:HEADER.CANCELLED_FLAG:SO_LOOKUPS:YES_NO:MEANING'
, '_LA:HEADER.DEMAND_CLASS_CODE:FND_COMMON_LOOKUPS:DEMAND_CLASS:MEANING'
, HEADER.PURCHASE_ORDER_NUM
, '_LA:HEADER.SHIPMENT_PRIORITY_CODE:SO_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, HEADER.SHIP_METHOD_CODE /* FK=CARRIER */
, '_LA:HEADER.FREIGHT_TERMS_CODE:SO_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:HEADER.FOB_CODE:AR_LOOKUPS:FOB:MEANING'
, '_DF:OE:SO_HEADERS:HEADER'
, ORDER_CYCLE.NAME
, SALESREP.NAME
, CUSTOMER.CUSTOMER_NAME
, AGREEMENT.NAME
, ORD_BY_CONTACT.FIRST_NAME||' '||ORD_BY_CONTACT.LAST_NAME
, INV_TO_CONTACT.FIRST_NAME||' '||INV_TO_CONTACT.LAST_NAME
, INV_TO_SITE.LOCATION
, SHIP_TO_CONTACT.FIRST_NAME||' '||SHIP_TO_CONTACT.LAST_NAME
, SHIP_TO_SITE.LOCATION
, INV_ORG.NAME
, INV_RULE.NAME
, ACCNT_RULE.NAME
, PAYTERMS.NAME
, PRICE_LIST.NAME
, CURRENCY.NAME
, SRC_HEADER.ORDER_NUMBER
, HEADER.HEADER_ID
, HEADER.ORDER_TYPE_ID
, HEADER.CYCLE_ID
, HEADER.SALESREP_ID
, HEADER.CUSTOMER_ID
, HEADER.AGREEMENT_ID
, HEADER.ORDERED_BY_CONTACT_ID
, HEADER.INVOICE_TO_CONTACT_ID
, HEADER.INVOICE_TO_SITE_USE_ID
, HEADER.SHIP_TO_CONTACT_ID
, HEADER.SHIP_TO_SITE_USE_ID
, HEADER.WAREHOUSE_ID
, HEADER.INVOICING_RULE_ID
, HEADER.ACCOUNTING_RULE_ID
, HEADER.TERMS_ID
, HEADER.PRICE_LIST_ID
, HEADER.CURRENCY_CODE
, HEADER.SOURCE_HEADER_ID
, HEADER.ORG_ID
, HEADER.LAST_UPDATE_DATE
, HEADER.LAST_UPDATED_BY
, HEADER.CREATION_DATE
, HEADER.CREATED_BY
FROM SO_HEADERS_ALL HEADER
, SO_ORDER_TYPES_ALL ORDER_TYPE
, SO_CYCLES ORDER_CYCLE
, RA_SALESREPS_ALL SALESREP
, RA_CUSTOMERS CUSTOMER
, SO_AGREEMENTS AGREEMENT
, RA_CONTACTS ORD_BY_CONTACT
, RA_CONTACTS INV_TO_CONTACT
, RA_SITE_USES_ALL INV_TO_SITE
, RA_CONTACTS SHIP_TO_CONTACT
, RA_SITE_USES_ALL SHIP_TO_SITE
, HR_ALL_ORGANIZATION_UNITS INV_ORG
, RA_RULES INV_RULE
, RA_RULES ACCNT_RULE
, RA_TERMS PAYTERMS
, SO_PRICE_LISTS PRICE_LIST
, FND_CURRENCIES_VL CURRENCY
, SO_HEADERS_ALL SRC_HEADER
, GL_DAILY_CONVERSION_TYPES GCT
WHERE HEADER.ORDER_TYPE_ID = ORDER_TYPE.ORDER_TYPE_ID
AND HEADER.WAREHOUSE_ID = INV_ORG.ORGANIZATION_ID(+)
AND HEADER.INVOICING_RULE_ID = INV_RULE.RULE_ID(+)
AND HEADER.ACCOUNTING_RULE_ID = ACCNT_RULE.RULE_ID(+)
AND HEADER.CUSTOMER_ID = CUSTOMER.CUSTOMER_ID(+)
AND HEADER.CYCLE_ID = ORDER_CYCLE.CYCLE_ID(+)
AND HEADER.CURRENCY_CODE = CURRENCY.CURRENCY_CODE
AND HEADER.SALESREP_ID = SALESREP.SALESREP_ID(+)
AND HEADER.AGREEMENT_ID = AGREEMENT.AGREEMENT_ID(+)
AND HEADER.ORDERED_BY_CONTACT_ID = ORD_BY_CONTACT.CONTACT_ID(+)
AND HEADER.INVOICE_TO_CONTACT_ID = INV_TO_CONTACT.CONTACT_ID(+)
AND HEADER.INVOICE_TO_SITE_USE_ID = INV_TO_SITE.SITE_USE_ID(+)
AND HEADER.SHIP_TO_CONTACT_ID = SHIP_TO_CONTACT.CONTACT_ID(+)
AND HEADER.SHIP_TO_SITE_USE_ID = SHIP_TO_SITE.SITE_USE_ID(+)
AND HEADER.TERMS_ID = PAYTERMS.TERM_ID(+)
AND HEADER.PRICE_LIST_ID = PRICE_LIST.PRICE_LIST_ID(+)
AND HEADER.SOURCE_HEADER_ID = SRC_HEADER.HEADER_ID(+)
AND HEADER.CONVERSION_TYPE_CODE = GCT.CONVERSION_TYPE(+) WITH READ ONLY

Columns