[Home] [Help] [Dependency Information]

VIEW: APPS.OE_ORDER_HEADERS_HIST_V

Object Details

Object Name:	OE_ORDER_HEADERS_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_ORDER_HEADERS_HIST_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT USER_ID
,      RESPONSIBILITY_ID
,      HIST_CREATION_DATE
,      HIST_COMMENTS
,      HIST_TYPE_CODE
,      REASON_CODE
,      PRICE_REQUEST_CODE
,      HEADER_ID
,      ORG_ID
,      ORDER_TYPE_ID
,      ORDER_NUMBER
,      VERSION_NUMBER
,      ORDER_SOURCE_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      ORIG_SYS_DOCUMENT_REF
,      SOURCE_DOCUMENT_ID
,      ORDERED_DATE
,      REQUEST_DATE
,      PRICING_DATE
,      SHIPMENT_PRIORITY_CODE
,      DEMAND_CLASS_CODE
,      PRICE_LIST_ID
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      CONVERSION_RATE
,      CONVERSION_RATE_DATE
,      CONVERSION_TYPE_CODE
,      PARTIAL_SHIPMENTS_ALLOWED
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      TRANSACTIONAL_CURR_CODE
,      AGREEMENT_ID
,      TAX_POINT_CODE
,      CUST_PO_NUMBER
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      ACCOUNTING_RULE_DURATION
,      PAYMENT_TERM_ID
,      SHIPPING_METHOD_CODE
,      FOB_POINT_CODE
,      FREIGHT_TERMS_CODE
,      SOLD_TO_ORG_ID
,      SOLD_TO_PHONE_ID
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      SOLD_TO_CONTACT_ID
,      SHIP_TO_CONTACT_ID
,      INVOICE_TO_CONTACT_ID
,      DELIVER_TO_CONTACT_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EXPIRATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      TP_CONTEXT
,      TP_ATTRIBUTE1
,      TP_ATTRIBUTE2
,      TP_ATTRIBUTE3
,      TP_ATTRIBUTE4
,      TP_ATTRIBUTE5
,      TP_ATTRIBUTE6
,      TP_ATTRIBUTE7
,      TP_ATTRIBUTE8
,      TP_ATTRIBUTE9
,      TP_ATTRIBUTE10
,      TP_ATTRIBUTE11
,      TP_ATTRIBUTE12
,      TP_ATTRIBUTE13
,      TP_ATTRIBUTE14
,      TP_ATTRIBUTE15
,      FREIGHT_CARRIER_CODE
,      CUSTOMER_NUMBER
,      ORDER_SOURCE
,      ORDER_TYPE
,      SOURCE_DOCUMENT_TYPE
,      AGREEMENT
,      PRICE_LIST
,      CONVERSION_TYPE
,      ACCOUNTING_RULE
,      INVOICING_RULE
,      TERMS
,      SOLD_TO
,      SHIP_FROM
,      SHIP_FROM_LOCATION
,      SHIP_FROM_ADDRESS1
,      SHIP_FROM_ADDRESS2
,      SHIP_FROM_ADDRESS3
,      SHIP_FROM_ADDRESS4
,      SHIP_TO
,      SHIP_TO_LOCATION
,      SHIP_TO_ADDRESS1
,      SHIP_TO_ADDRESS2
,      SHIP_TO_ADDRESS3
,      SHIP_TO_ADDRESS4
,      SHIP_TO_ADDRESS5
,      DELIVER_TO
,      DELIVER_TO_LOCATION
,      DELIVER_TO_ADDRESS1
,      DELIVER_TO_ADDRESS2
,      DELIVER_TO_ADDRESS3
,      DELIVER_TO_ADDRESS4
,      INVOICE_TO
,      INVOICE_TO_LOCATION
,      INVOICE_TO_ADDRESS1
,      INVOICE_TO_ADDRESS2
,      INVOICE_TO_ADDRESS3
,      INVOICE_TO_ADDRESS4
,      INVOICE_TO_ADDRESS5
,      SOLD_TO_CONTACT
,      SHIP_TO_CONTACT
,      INVOICE_TO_CONTACT
,      DELIVER_TO_CONTACT
,      SALESREP_ID
,      RETURN_REASON_CODE
,      RETURN_REASON
,      ORDER_DATE_TYPE_CODE
,      EARLIEST_SCHEDULE_LIMIT
,      LATEST_SCHEDULE_LIMIT
,      PAYMENT_TYPE_CODE
,      PAYMENT_AMOUNT
,      CHECK_NUMBER
,      CREDIT_CARD_CODE
,      CREDIT_CARD_HOLDER_NAME
,      CREDIT_CARD_NUMBER
,      CREDIT_CARD_EXPIRATION_DATE
,      CREDIT_CARD_APPROVAL_CODE
,      CREDIT_CARD_APPROVAL_DATE
,      FIRST_ACK_CODE
,      FIRST_ACK_DATE
,      LAST_ACK_CODE
,      LAST_ACK_DATE
,      BOOKED_FLAG
,      BOOKED_DATE
,      CANCELLED_FLAG
,      OPEN_FLAG
,      SOLD_FROM_ORG_ID
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      ORDER_CATEGORY_CODE
,      FLOW_STATUS_CODE
,      FREIGHT_CARRIER
,      CUSTOMER_PREFERENCE_SET_CODE
,      SALES_CHANNEL_CODE
,      UPGRADED_FLAG
,      LOCK_CONTROL
,      SOLD_TO_EMAIL_ADDRESS
,      GSA_INDICATOR
,      BLANKET_NUMBER
,      QUOTE_DATE
,      QUOTE_NUMBER
,      SALES_DOCUMENT_NAME
,      TRANSACTION_PHASE_CODE
,      USER_STATUS_CODE
,      DRAFT_SUBMITTED_FLAG
,      SOURCE_DOCUMENT_VERSION_NUMBER
,      SOLD_TO_SITE_USE_ID
,      SUPPLIER_SIGNATURE
,      SUPPLIER_SIGNATURE_DATE
,      CUSTOMER_SIGNATURE
,      CUSTOMER_SIGNATURE_DATE
,      REASON_ID
,      AUDIT_FLAG
,      VERSION_FLAG
,      PHASE_CHANGE_FLAG
,      MINISITE_ID
,      END_CUSTOMER_ID
,      END_CUSTOMER_CONTACT_ID
,      END_CUSTOMER_SITE_USE_ID
,      END_CUSTOMER_NAME
,      END_CUSTOMER_NUMBER
,      END_CUSTOMER_CONTACT
,      END_CUSTOMER_LOCATION
,      END_CUSTOMER_ADDRESS1
,      END_CUSTOMER_ADDRESS2
,      END_CUSTOMER_ADDRESS3
,      END_CUSTOMER_ADDRESS4
,      END_CUSTOMER_ADDRESS5
,      IB_OWNER
,      IB_CURRENT_LOCATION
,      IB_INSTALLED_AT_LOCATION
,      TRANSACTION_PHASE
,      ORDER_FIRMED_DATE
,      INSTRUMENT_ID
FROM APPS.OE_ORDER_HEADERS_HIST_V;

Dependencies

[top of page]

APPS

AR_LOOKUPS

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_ROLES

HZ_CUST_ACCT_SITES_ALL

HZ_CUST_SITE_USES_ALL

HZ_LOCATIONS

HZ_PARTIES

HZ_PARTY_SITES

HZ_RELATIONSHIPS

MTL_PARAMETERS

OE_LOOKUPS

OE_ORDER_HEADER_HISTORY

OE_TRANSACTION_TYPES_TL

QP_LIST_HEADERS_TL

RA_RULES

RA_TERMS_TL

APPS.OE_ORDER_HEADERS_HIST_V is not referenced by any database object