[Home] [Help]
View: OE_ORDER_HEADERS_RM_V
View Text
SELECT
H.HEADER_ID
,
H.ORDER_NUMBER
,
'SALES_ORDER' DOCUMENT_TYPE_CODE
,
OT.NAME ORDER_TYPE
,
H.ORDERED_DATE
,
H.CREATION_DATE
,
H.LAST_UPDATE_DATE
,
H.CONVERSION_RATE
,
H.CONVERSION_TYPE_CODE
,
H.CONVERSION_RATE_DATE
,
H.TRANSACTIONAL_CURR_CODE
,
H.FLOW_STATUS_CODE
,
H.SALESREP_ID
,
H.INVOICING_RULE_ID
,
H.ACCOUNTING_RULE_ID
,
H.PAYMENT_TERM_ID
,
H.SOLD_FROM_ORG_ID
,
H.SOLD_TO_ORG_ID
,
H.SHIP_FROM_ORG_ID
,
H.SHIP_TO_ORG_ID
,
H.INVOICE_TO_CONTACT_ID
,
H.INVOICE_TO_ORG_ID
,
H.ORG_ID
,
H.CUST_PO_NUMBER
,
H.BLANKET_NUMBER
,
H.QUOTE_NUMBER
,
H.CANCELLED_FLAG
,
H.OPEN_FLAG
,
H.SHIPPING_METHOD_CODE
,
H.FREIGHT_CARRIER_CODE
,
H.FOB_POINT_CODE
,
H.FREIGHT_TERMS_CODE
,
H.RETURN_REASON_CODE
,
H.SALES_CHANNEL_CODE
,
H.SOLD_TO_SITE_USE_ID
,
H.END_CUSTOMER_ID
,
H.END_CUSTOMER_CONTACT_ID
,
H.END_CUSTOMER_SITE_USE_ID
,
H.CONTEXT
,
H.ATTRIBUTE1
,
H.ATTRIBUTE2
,
H.ATTRIBUTE3
,
H.ATTRIBUTE4
,
H.ATTRIBUTE5
,
H.ATTRIBUTE6
,
H.ATTRIBUTE7
,
H.ATTRIBUTE8
,
H.ATTRIBUTE9
,
H.ATTRIBUTE10
,
H.ATTRIBUTE11
,
H.ATTRIBUTE12
,
H.ATTRIBUTE13
,
H.ATTRIBUTE14
,
H.ATTRIBUTE15
,
H.ATTRIBUTE16
,
H.ATTRIBUTE17
,
H.ATTRIBUTE18
,
H.ATTRIBUTE19
,
H.ATTRIBUTE20
,
H.ACCOUNTING_RULE_DURATION
,
DECODE(H.ORDER_SOURCE_ID
, 10
, 'INTERNAL'
, 'EXTERNAL') ORDER_SOURCE
FROM OE_ORDER_HEADERS_ALL H
, OE_TRANSACTION_TYPES_TL OT
WHERE
H.ORDER_TYPE_ID = OT.TRANSACTION_TYPE_ID
AND OT.LANGUAGE = (SELECT LANGUAGE_CODE
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG='B')
AND H.BOOKED_FLAG = 'Y'