DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.OE_ORDER_HEADERS_RM_V

Object Details
Object Name: OE_ORDER_HEADERS_RM_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_ORDER_HEADERS_RM_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER
Yes
ORDER_NUMBER NUMBER
Yes
DOCUMENT_TYPE_CODE CHAR (11)
ORDER_TYPE VARCHAR2 (30) Yes
ORDERED_DATE DATE

CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
CONVERSION_RATE NUMBER

CONVERSION_TYPE_CODE VARCHAR2 (30)
CONVERSION_RATE_DATE DATE

TRANSACTIONAL_CURR_CODE VARCHAR2 (15)
FLOW_STATUS_CODE VARCHAR2 (30)
SALESREP_ID NUMBER (15)
INVOICING_RULE_ID NUMBER (15)
ACCOUNTING_RULE_ID NUMBER (15)
PAYMENT_TERM_ID NUMBER (15)
SOLD_FROM_ORG_ID NUMBER

SOLD_TO_ORG_ID NUMBER

SHIP_FROM_ORG_ID NUMBER

SHIP_TO_ORG_ID NUMBER

INVOICE_TO_CONTACT_ID NUMBER

INVOICE_TO_ORG_ID NUMBER

ORG_ID NUMBER

CUST_PO_NUMBER VARCHAR2 (50)
BLANKET_NUMBER NUMBER

QUOTE_NUMBER NUMBER

CANCELLED_FLAG VARCHAR2 (1)
OPEN_FLAG VARCHAR2 (1) Yes
SHIPPING_METHOD_CODE VARCHAR2 (30)
FREIGHT_CARRIER_CODE VARCHAR2 (30)
FOB_POINT_CODE VARCHAR2 (30)
FREIGHT_TERMS_CODE VARCHAR2 (30)
RETURN_REASON_CODE VARCHAR2 (30)
SALES_CHANNEL_CODE VARCHAR2 (30)
SOLD_TO_SITE_USE_ID NUMBER

END_CUSTOMER_ID NUMBER

END_CUSTOMER_CONTACT_ID NUMBER

END_CUSTOMER_SITE_USE_ID NUMBER

CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
ACCOUNTING_RULE_DURATION NUMBER (15)
ORDER_SOURCE VARCHAR2 (8)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HEADER_ID
,      ORDER_NUMBER
,      DOCUMENT_TYPE_CODE
,      ORDER_TYPE
,      ORDERED_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CONVERSION_RATE
,      CONVERSION_TYPE_CODE
,      CONVERSION_RATE_DATE
,      TRANSACTIONAL_CURR_CODE
,      FLOW_STATUS_CODE
,      SALESREP_ID
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      PAYMENT_TERM_ID
,      SOLD_FROM_ORG_ID
,      SOLD_TO_ORG_ID
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      INVOICE_TO_CONTACT_ID
,      INVOICE_TO_ORG_ID
,      ORG_ID
,      CUST_PO_NUMBER
,      BLANKET_NUMBER
,      QUOTE_NUMBER
,      CANCELLED_FLAG
,      OPEN_FLAG
,      SHIPPING_METHOD_CODE
,      FREIGHT_CARRIER_CODE
,      FOB_POINT_CODE
,      FREIGHT_TERMS_CODE
,      RETURN_REASON_CODE
,      SALES_CHANNEL_CODE
,      SOLD_TO_SITE_USE_ID
,      END_CUSTOMER_ID
,      END_CUSTOMER_CONTACT_ID
,      END_CUSTOMER_SITE_USE_ID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ACCOUNTING_RULE_DURATION
,      ORDER_SOURCE
FROM APPS.OE_ORDER_HEADERS_RM_V;

Dependencies

[top of page]

APPS.OE_ORDER_HEADERS_RM_V references the following:

SchemaAPPS
SynonymFND_LANGUAGES
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_TRANSACTION_TYPES_TL

APPS.OE_ORDER_HEADERS_RM_V is not referenced by any database object