[Home] [Help] [Dependency Information]

VIEW: APPS.OE_BLKT_HEADERS_HIST_V

Object Details

Object Name:	OE_BLKT_HEADERS_HIST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_BLKT_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 ROW_ID
,      HEADER_ID
,      ORG_ID
,      ORDER_TYPE_ID
,      ORDER_NUMBER
,      VERSION_NUMBER
,      EXPIRATION_DATE
,      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_TYPE_CODE
,      CONVERSION_RATE_DATE
,      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
,      PAYMENT_TERM_ID
,      SHIPPING_METHOD_CODE
,      FREIGHT_CARRIER_CODE
,      FOB_POINT_CODE
,      FREIGHT_TERMS_CODE
,      SOLD_FROM_ORG_ID
,      SOLD_TO_ORG_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_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      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
,      CANCELLED_FLAG
,      OPEN_FLAG
,      BOOKED_FLAG
,      SALESREP_ID
,      RETURN_REASON_CODE
,      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
,      SALES_CHANNEL_CODE
,      FIRST_ACK_CODE
,      FIRST_ACK_DATE
,      LAST_ACK_CODE
,      LAST_ACK_DATE
,      ORDER_CATEGORY_CODE
,      CHANGE_SEQUENCE
,      DROP_SHIP_FLAG
,      CUSTOMER_PAYMENT_TERM_ID
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      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
,      FLOW_STATUS_CODE
,      MARKETING_SOURCE_CODE_ID
,      CREDIT_CARD_APPROVAL_DATE
,      UPGRADED_FLAG
,      CUSTOMER_PREFERENCE_SET_CODE
,      BOOKED_DATE
,      LOCK_CONTROL
,      PRICE_REQUEST_CODE
,      BATCH_ID
,      XML_MESSAGE_ID
,      BLANKET_NUMBER
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ENFORCE_PRICE_LIST_FLAG
,      RELEASED_AMOUNT
,      REVISION_CHANGE_REASON_CODE
,      REVISION_REASON_CODE
,      REVISION_CHANGE_COMMENTS
,      ON_HOLD_FLAG
,      BLANKET_MIN_AMOUNT
,      BLANKET_MAX_AMOUNT
,      OVERRIDE_AMOUNT_FLAG
,      RETURNED_AMOUNT
,      REVISION_CHANGE_DATE
,      CUSTOMER_NUMBER
,      ORDER_TYPE
,      AGREEMENT
,      PRICE_LIST_NAME
,      ACCOUNTING_RULE
,      INVOICING_RULE
,      TERMS
,      SOLD_TO
,      SHIP_FROM
,      SHIP_FROM_LOCATION
,      SHIP_FROM_ADDRESS1
,      SHIP_FROM_ADDRESS2
,      SHIP_FROM_ADDRESS3
,      SHIP_FROM_ADDRESS4
,      SOLD_TO_CONTACT
,      ENFORCE_SHIP_TO_FLAG
,      ENFORCE_INVOICE_TO_FLAG
,      ENFORCE_FREIGHT_TERM_FLAG
,      ENFORCE_SHIPPING_METHOD_FLAG
,      ENFORCE_PAYMENT_TERM_FLAG
,      ENFORCE_ACCOUNTING_RULE_FLAG
,      ENFORCE_INVOICING_RULE_FLAG
,      FULFILLED_AMOUNT
,      SALES_DOCUMENT_NAME
,      TRANSACTION_PHASE_CODE
,      USER_STATUS_CODE
,      SUPPLIER_SIGNATURE
,      SUPPLIER_SIGNATURE_DATE
,      CUSTOMER_SIGNATURE
,      CUSTOMER_SIGNATURE_DATE
,      SOLD_TO_SITE_USE_ID
,      DRAFT_SUBMITTED_FLAG
,      SOURCE_DOCUMENT_VERSION_NUMBER
,      QUOTE_NUMBER
,      QUOTE_DATE
,      NEW_PRICE_LIST_ID
,      NEW_MODIFIER_LIST_ID
,      DEFAULT_DISCOUNT_PERCENT
,      DEFAULT_DISCOUNT_AMOUNT
FROM APPS.OE_BLKT_HEADERS_HIST_V;

Dependencies

[top of page]

APPS

AR_LOOKUPS

FND_CURRENCIES

HZ_CUST_ACCOUNTS

HZ_CUST_ACCOUNT_ROLES

HZ_PARTIES

HZ_RELATIONSHIPS

MTL_PARAMETERS

OE_BLANKET_FORM_CONTROL - show dependent code

OE_BLANKET_HEADERS

OE_BLANKET_HEADERS_EXT

OE_BLANKET_HEADERS_HIST

OE_LOOKUPS

OE_TRANSACTION_TYPES_TL

QP_LIST_HEADERS_TL

RA_RULES

RA_TERMS_TL

APPS.OE_BLKT_HEADERS_HIST_V is not referenced by any database object