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

VIEW: APPS.OE_AK_BLANKET_HEADERS_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCOUNTING_RULE_ID NUMBER (15)
Accounting Rule used by the AR for generating Invoice
CONVERSION_TYPE_CODE VARCHAR2 (30)
Currency Conversion Type
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who Column
CUST_PO_NUMBER VARCHAR2 (50)
Customer Purchase Order Number
DELIVER_TO_ORG_ID NUMBER

Deliver to Organization ID
FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight Terms Code
HEADER_ID NUMBER
Yes Blanket Header Identifier
INVOICE_TO_ORG_ID NUMBER

Invoice to Organization ID
INVOICING_RULE_ID NUMBER (15)
Invoicing rule used by AR, for generating Invoice
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
ORDER_NUMBER NUMBER
Yes User-Visibile number of the blanket
ORDER_TYPE_ID NUMBER
Yes Blanket Transaction Type identifier
ORG_ID NUMBER

Operating Unit which performed this transaction
PAYMENT_TERM_ID NUMBER (15)
Payment Terms
PRICE_LIST_ID NUMBER

Price List identification for the blanket
PROGRAM_APPLICATION_ID NUMBER

Application of Concurrent Program that last updated row.
PROGRAM_ID NUMBER

Concurrent Program that last updated row
PROGRAM_UPDATE_DATE DATE

Last Date Changed by Concurrent Program
SALESREP_ID NUMBER (15)
Sales Representative Identification
SHIPPING_METHOD_CODE VARCHAR2 (30)
Shipping method to be used to ship the blanket.
SHIP_FROM_ORG_ID NUMBER

Ship from Organization ID - Warehouse
SHIP_TO_ORG_ID NUMBER

Ship to Organization ID
SOLD_TO_CONTACT_ID NUMBER

Customer Contact
SOLD_TO_ORG_ID NUMBER

Sold to Customer
TRANSACTIONAL_CURR_CODE VARCHAR2 (15)
Currency for the blanket
VERSION_NUMBER NUMBER
Yes Revision Number of the blanket
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Shipping Instructions for Blanket
PACKING_INSTRUCTIONS VARCHAR2 (2000)
Packing Instructions for Blanket
START_DATE_ACTIVE DATE

Activation Date of the blanket
END_DATE_ACTIVE DATE

Expiration Date of the blanket
REVISION_CHANGE_DATE DATE

Date revision occurred
REVISION_CHANGE_REASON_CODE VARCHAR2 (30)
Stored revision code for blanket revision
REVISION_CHANGE_COMMENTS VARCHAR2 (2000)
Stored Comments for blanket revision
ENFORCE_SHIP_TO_FLAG VARCHAR2 (1) Yes Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_FREIGHT_TERM_FLAG VARCHAR2 (1) Yes Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_SHIPPING_METHOD_FLAG VARCHAR2 (1) Yes Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_PRICE_LIST_FLAG VARCHAR2 (1) Yes Defaulting Source for flag of same name on OE_BLANKET_LINES
ENFORCE_PAYMENT_TERM_FLAG VARCHAR2 (1) Yes Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_INVOICE_TO_FLAG VARCHAR2 (1) Yes Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_INVOICING_RULE_FLAG VARCHAR2 (1) Yes Defaulting source for flag of same name on OE_BLANKET_LINES
ENFORCE_ACCOUNTING_RULE_FLAG VARCHAR2 (1) Yes Defaulting source for flag of same name on OE_BLANKET_LINES
BLANKET_MIN_AMOUNT NUMBER

Minimum currency amount allowed for blanket
BLANKET_MAX_AMOUNT NUMBER

Maximum Currency amount allowed for blanket
OVERRIDE_AMOUNT_FLAG VARCHAR2 (1) Yes Allow Override of Min/max amounts for this blanket
ON_HOLD_FLAG VARCHAR2 (1)
Disallow New Releases: Possible Values:Y/N
SALES_DOCUMENT_NAME VARCHAR2 (240)
Stores Quote Name for Orders under negotiation.
TRANSACTION_PHASE_CODE VARCHAR2 (30)
Indicates if Transaction is in negotitation or fulfillment phase
USER_STATUS_CODE VARCHAR2 (30)
User entered status
SUPPLIER_SIGNATURE VARCHAR2 (240)
Supplier Name
SUPPLIER_SIGNATURE_DATE DATE

Date when supplier signed on the document.
CUSTOMER_SIGNATURE VARCHAR2 (240)
Customer Name
CUSTOMER_SIGNATURE_DATE DATE

Date when customer signed on the document
SOLD_TO_SITE_USE_ID NUMBER

Customer Location
DRAFT_SUBMITTED_FLAG VARCHAR2 (1)
Internal Use only
SOURCE_DOCUMENT_VERSION_NUMBER NUMBER

Internal Use only
QUOTE_NUMBER NUMBER

This is populated for Orders under negotiation
QUOTE_DATE DATE

Populated using defaulting rules.
FLOW_STATUS_CODE VARCHAR2 (30)
Workflow Status for the header
SOURCE_DOCUMENT_TYPE_ID NUMBER

Indicates the source of the blanket
NEW_MODIFIER_LIST_ID NUMBER

NEW_PRICE_LIST_ID NUMBER

DEFAULT_DISCOUNT_PERCENT NUMBER

DEFAULT_DISCOUNT_AMOUNT NUMBER

CONTRACT_TERMS NUMBER

OPEN_FLAG VARCHAR2 (1) Yes
CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive Flexfield segment
Query Text

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


SELECT ACCOUNTING_RULE_ID
,      CONVERSION_TYPE_CODE
,      CREATED_BY
,      CREATION_DATE
,      CUST_PO_NUMBER
,      DELIVER_TO_ORG_ID
,      FREIGHT_TERMS_CODE
,      HEADER_ID
,      INVOICE_TO_ORG_ID
,      INVOICING_RULE_ID
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORDER_NUMBER
,      ORDER_TYPE_ID
,      ORG_ID
,      PAYMENT_TERM_ID
,      PRICE_LIST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SALESREP_ID
,      SHIPPING_METHOD_CODE
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      SOLD_TO_CONTACT_ID
,      SOLD_TO_ORG_ID
,      TRANSACTIONAL_CURR_CODE
,      VERSION_NUMBER
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      REVISION_CHANGE_DATE
,      REVISION_CHANGE_REASON_CODE
,      REVISION_CHANGE_COMMENTS
,      ENFORCE_SHIP_TO_FLAG
,      ENFORCE_FREIGHT_TERM_FLAG
,      ENFORCE_SHIPPING_METHOD_FLAG
,      ENFORCE_PRICE_LIST_FLAG
,      ENFORCE_PAYMENT_TERM_FLAG
,      ENFORCE_INVOICE_TO_FLAG
,      ENFORCE_INVOICING_RULE_FLAG
,      ENFORCE_ACCOUNTING_RULE_FLAG
,      BLANKET_MIN_AMOUNT
,      BLANKET_MAX_AMOUNT
,      OVERRIDE_AMOUNT_FLAG
,      ON_HOLD_FLAG
,      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
,      FLOW_STATUS_CODE
,      SOURCE_DOCUMENT_TYPE_ID
,      NEW_MODIFIER_LIST_ID
,      NEW_PRICE_LIST_ID
,      DEFAULT_DISCOUNT_PERCENT
,      DEFAULT_DISCOUNT_AMOUNT
,      CONTRACT_TERMS
,      OPEN_FLAG
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
FROM APPS.OE_AK_BLANKET_HEADERS_V;

Dependencies

[top of page]

APPS.OE_AK_BLANKET_HEADERS_V references the following:

SchemaAPPS
SynonymOE_BLANKET_HEADERS_ALL
SynonymOE_BLANKET_HEADERS_EXT
APPS.OE_AK_BLANKET_HEADERS_V is referenced by following:

SchemaAPPS
Package BodyOE_1018PC1018_BLKTHDR_BKDISNR - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BKLOST - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLACTIV - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLAWSTA - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLCLOSE - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLCUSAC - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLCUSRJ - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLCUSSG - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLDRAFT - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLDRSUB - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLEXPIR - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLINTAP - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLINTRJ - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLNEGCO - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLPENAP - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLPENCA - show dependent code
Package BodyOE_1018PC1018_BLKTHDR_BLTERMI - show dependent code
Package BodyOE_1018PC1_ORDER_AHLORD - show dependent code
Package BodyOE_1018PC1_ORDER_BOOKED - show dependent code
Package BodyOE_1018PC1_ORDER_CANORD - show dependent code
Package BodyOE_1018PC1_ORDER_CLOSED - show dependent code
Package BodyOE_1018PC1_ORDER_CUSTACC - show dependent code
Package BodyOE_1018PC1_ORDER_CUSTREJ - show dependent code
Package BodyOE_1018PC1_ORDER_CUSTSIG - show dependent code
Package BodyOE_1018PC1_ORDER_DEALAPP - show dependent code
Package BodyOE_1018PC1_ORDER_DEALSUB - show dependent code
Package BodyOE_1018PC1_ORDER_DRAFSUB - show dependent code
Package BodyOE_1018PC1_ORDER_DRAFT - show dependent code
Package BodyOE_1018PC1_ORDER_ENTER - show dependent code
Package BodyOE_1018PC1_ORDER_HDRINVC - show dependent code
Package BodyOE_1018PC1_ORDER_INTAPPR - show dependent code
Package BodyOE_1018PC1_ORDER_INTORD - show dependent code
Package BodyOE_1018PC1_ORDER_INTREJ - show dependent code
Package BodyOE_1018PC1_ORDER_LOST - show dependent code
Package BodyOE_1018PC1_ORDER_NEGCOMP - show dependent code
Package BodyOE_1018PC1_ORDER_OFFEXP - show dependent code
Package BodyOE_1018PC1_ORDER_PENAPPR - show dependent code
Package BodyOE_1018PC1_ORDER_PENCUSA - show dependent code
Package BodyOE_1018PC1_ORDER_REGORD - show dependent code
Package BodyOE_1018PC1_ORDER_RETAPVD - show dependent code
Package BodyOE_1018PC1_ORDER_RETORD - show dependent code
Package BodyOE_1018PC1_ORDER_RETREJ - show dependent code
Package BodyOE_1018PC1_ORDER_RETREJA - show dependent code
Package BodyOE_1018PC1_ORDER_RETREJD - show dependent code
Package BodyOE_1018PC2_LINE_AHLLINE - show dependent code
Package BodyOE_1018PC2_LINE_ATO - show dependent code
Package BodyOE_1018PC2_LINE_ATOCOMP - show dependent code
Package BodyOE_1018PC2_LINE_BKDRET - show dependent code
Package BodyOE_1018PC2_LINE_BOOKED - show dependent code
Package BodyOE_1018PC2_LINE_BRANCH - show dependent code
Package BodyOE_1018PC2_LINE_CANLINE - show dependent code
Package BodyOE_1018PC2_LINE_CLOSED - show dependent code
Package BodyOE_1018PC2_LINE_CRTSUP - show dependent code
Package BodyOE_1018PC2_LINE_ECSUPDT - show dependent code
Package BodyOE_1018PC2_LINE_ENTER - show dependent code
Package BodyOE_1018PC2_LINE_EXPCOMP - show dependent code
Package BodyOE_1018PC2_LINE_EXTLINE - show dependent code
Package BodyOE_1018PC2_LINE_FULFILL - show dependent code
Package BodyOE_1018PC2_LINE_INCITEM - show dependent code
Package BodyOE_1018PC2_LINE_INVIFAC - show dependent code
Package BodyOE_1018PC2_LINE_INVOICE - show dependent code
Package BodyOE_1018PC2_LINE_ISOL - show dependent code
Package BodyOE_1018PC2_LINE_NAINV - show dependent code
Package BodyOE_1018PC2_LINE_PRCONF - show dependent code
Package BodyOE_1018PC2_LINE_PURREL - show dependent code
Package BodyOE_1018PC2_LINE_RCVED - show dependent code
Package BodyOE_1018PC2_LINE_REGLINE - show dependent code
Package BodyOE_1018PC2_LINE_RETLIN - show dependent code
Package BodyOE_1018PC2_LINE_RETROLN - show dependent code
Package BodyOE_1018PC2_LINE_RLMLIN - show dependent code
Package BodyOE_1018PC2_LINE_RTLAPVD - show dependent code
Package BodyOE_1018PC2_LINE_RTLREJD - show dependent code
Package BodyOE_1018PC2_LINE_SCHEXST - show dependent code
Package BodyOE_1018PC2_LINE_SERVICE - show dependent code
Package BodyOE_1018PC2_LINE_SHIPA - show dependent code
Package BodyOE_1018PC2_LINE_SHIPC - show dependent code
Package BodyOE_1018PC2_LINE_SHPCNF - show dependent code
Package BodyOE_1018PC2_LINE_STANDAR - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BKDISNR - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BKLOST - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLACTIV - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLAWSTA - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLCLOSE - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLCUSAC - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLCUSRJ - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLCUSSG - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLDRAFT - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLDRSUB - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLEXPIR - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLINTAP - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLINTRJ - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLNEGCO - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLPENAP - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLPENCA - show dependent code
Package BodyOE_1019PC1018_BLKTHDR_BLTERMI - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BKDISNR - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BKLOST - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLACTIV - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLAWSTA - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLCLOSE - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLCUSAC - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLCUSRJ - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLCUSSG - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLDRAFT - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLDRSUB - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLEXPIR - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLINTAP - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLINTRJ - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLNEGCO - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLPENAP - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLPENCA - show dependent code
Package BodyOE_1PC1018_BLKTHDR_BLTERMI - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BKDISNR - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BKLOST - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLACTIV - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLAWSTA - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLCLOSE - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLCUSAC - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLCUSRJ - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLCUSSG - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLDRAFT - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLDRSUB - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLEXPIR - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLINTAP - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLINTRJ - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLNEGCO - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLPENAP - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLPENCA - show dependent code
Package BodyOE_2PC1018_BLKTHDR_BLTERMI - show dependent code
Package BodyOE_BLANKET_FORM_CONTROL - show dependent code
Package BodyOE_BLANKET_HEADER_SECURITY - show dependent code
PL/SQL PackageOE_BLANKET_HEADER_SECURITY - show dependent code
Package BodyOE_BLANKET_UTIL - show dependent code
PL/SQL PackageOE_BLANKET_UTIL - show dependent code
Package BodyOE_BLANKET_WF_UTIL - show dependent code
Package BodyOE_ORDER_GRP - show dependent code
PL/SQL PackageONT_BLANKET_HEADER_DEF_UTIL - show dependent code
Package BodyONT_BLANKET_HEADER_DEF_UTIL - show dependent code