VIEW: APPS.OE_ORDER_HEADERS_RM_V

Source

View Text - Preformatted

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'
   

View Text - HTML Formatted

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'