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

VIEW: APPS.OE_AK_BLANKET_LINES_V

Object Details
Object Name: OE_AK_BLANKET_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewONT.OE_AK_BLANKET_LINES_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
ORDER_NUMBER NUMBER
Yes User Visible number of the blanket
LINE_NUMBER NUMBER

User Visible number of blanket line
LINE_ID NUMBER

Foreign Key reference to OE_BLANKET_LINES_ALL
SHIP_TO_ORG_ID NUMBER

Ship to Organization Id
INVOICE_TO_ORG_ID NUMBER

Invoice to Organization Id
DELIVER_TO_ORG_ID NUMBER

Deliver to Organization Id
SHIP_FROM_ORG_ID NUMBER

Ship from Organization ID - Warehouse
PRICE_LIST_ID NUMBER

Price List
CUST_PO_NUMBER VARCHAR2 (50)
Customer Purchase Order Number
INVOICING_RULE_ID NUMBER (15)
Invoicing rule used by AR for generating Invoice
ACCOUNTING_RULE_ID NUMBER (15)
Accounting rule used by AR for generating Invoice.
PAYMENT_TERM_ID NUMBER (15)
Payment Terms
SHIPPING_METHOD_CODE VARCHAR2 (30)
Shipping method
FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight Terms, specifying the responsibility of the freight
SALESREP_ID NUMBER (15)
Sales Representative Id
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Shipping Instructions for Line
PACKING_INSTRUCTIONS VARCHAR2 (2000)
Packing Instructions for Line
PREFERRED_GRADE VARCHAR2 (150)
Grade requested by the customer
ITEM_IDENTIFIER_TYPE VARCHAR2 (30)
To distinguish different types of Item (Intrnal/Custom)
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
ORDER_QUANTITY_UOM VARCHAR2 (3)
Blanketed Quantity Unit of Measure
START_DATE_ACTIVE DATE

Activation date of blanket line
END_DATE_ACTIVE DATE

Expiration Date of blanket line
ENFORCE_SHIP_TO_FLAG VARCHAR2 (1) Yes Enforces Ship To on release line
ENFORCE_SHIPPING_METHOD_FLAG VARCHAR2 (1) Yes Enforces Shipping Method on release line
ENFORCE_FREIGHT_TERM_FLAG VARCHAR2 (1) Yes Enforces Freight Term on Release Line
ENFORCE_INVOICE_TO_FLAG VARCHAR2 (1) Yes Enforces Invoice To on release Line
UNIT_LIST_PRICE NUMBER

Not Used
ENFORCE_PRICE_LIST_FLAG VARCHAR2 (1) Yes Enforces price list on release line
ENFORCE_PAYMENT_TERM_FLAG VARCHAR2 (1) Yes Enforces Payment Term on release line
ENFORCE_INVOICING_RULE_FLAG VARCHAR2 (1) Yes Enforces Invoicing Rule on Release line
BLANKET_LINE_MIN_AMOUNT NUMBER

Minimum total currency amount allowed
BLANKET_LINE_MAX_AMOUNT NUMBER

Maximum total currency amount allowed
BLANKET_MIN_QUANTITY NUMBER

Minimum total quantity allowed
BLANKET_MAX_QUANTITY NUMBER

Maximum total quantity allowed
MIN_RELEASE_AMOUNT NUMBER

Minimum release currency amount allowed
MAX_RELEASE_AMOUNT NUMBER

Maximum release currency amount allowed
MIN_RELEASE_QUANTITY NUMBER

Minimum release quantity
MAX_RELEASE_QUANTITY NUMBER

Maximum release quantity
OVERRIDE_BLANKET_CONTROLS_FLAG VARCHAR2 (1) Yes Allow override of min/max values
OVERRIDE_RELEASE_CONTROLS_FLAG VARCHAR2 (1) Yes Allow Override of min/max release values
TRANSACTION_PHASE_CODE VARCHAR2 (30)
Indicates if Transaction is in negotitation or fulfillment phase
SOURCE_DOCUMENT_VERSION_NUMBER NUMBER

Internal Use Only.
SOURCE_DOCUMENT_TYPE_ID NUMBER

Indicates the source of the blanket
ENFORCE_ACCOUNTING_RULE_FLAG VARCHAR2 (1) Yes Enforces accounting rule on release line
MODIFIER_LIST_LINE_ID NUMBER

DISCOUNT_AMOUNT NUMBER

DISCOUNT_PERCENT NUMBER

PRICING_QUANTITY_UOM VARCHAR2 (30)
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 ORDER_NUMBER
,      LINE_NUMBER
,      LINE_ID
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      SHIP_FROM_ORG_ID
,      PRICE_LIST_ID
,      CUST_PO_NUMBER
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      PAYMENT_TERM_ID
,      SHIPPING_METHOD_CODE
,      FREIGHT_TERMS_CODE
,      SALESREP_ID
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      PREFERRED_GRADE
,      ITEM_IDENTIFIER_TYPE
,      INVENTORY_ITEM_ID
,      ORDER_QUANTITY_UOM
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ENFORCE_SHIP_TO_FLAG
,      ENFORCE_SHIPPING_METHOD_FLAG
,      ENFORCE_FREIGHT_TERM_FLAG
,      ENFORCE_INVOICE_TO_FLAG
,      UNIT_LIST_PRICE
,      ENFORCE_PRICE_LIST_FLAG
,      ENFORCE_PAYMENT_TERM_FLAG
,      ENFORCE_INVOICING_RULE_FLAG
,      BLANKET_LINE_MIN_AMOUNT
,      BLANKET_LINE_MAX_AMOUNT
,      BLANKET_MIN_QUANTITY
,      BLANKET_MAX_QUANTITY
,      MIN_RELEASE_AMOUNT
,      MAX_RELEASE_AMOUNT
,      MIN_RELEASE_QUANTITY
,      MAX_RELEASE_QUANTITY
,      OVERRIDE_BLANKET_CONTROLS_FLAG
,      OVERRIDE_RELEASE_CONTROLS_FLAG
,      TRANSACTION_PHASE_CODE
,      SOURCE_DOCUMENT_VERSION_NUMBER
,      SOURCE_DOCUMENT_TYPE_ID
,      ENFORCE_ACCOUNTING_RULE_FLAG
,      MODIFIER_LIST_LINE_ID
,      DISCOUNT_AMOUNT
,      DISCOUNT_PERCENT
,      PRICING_QUANTITY_UOM
,      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_LINES_V;

Dependencies

[top of page]

APPS.OE_AK_BLANKET_LINES_V references the following:

SchemaAPPS
SynonymOE_BLANKET_LINES
SynonymOE_BLANKET_LINES_EXT
APPS.OE_AK_BLANKET_LINES_V is referenced by following:

SchemaAPPS
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_1019PC2_LINE_AHLLINE - show dependent code
Package BodyOE_1019PC2_LINE_ATO - show dependent code
Package BodyOE_1019PC2_LINE_ATOCOMP - show dependent code
Package BodyOE_1019PC2_LINE_BKDRET - show dependent code
Package BodyOE_1019PC2_LINE_BOOKED - show dependent code
Package BodyOE_1019PC2_LINE_BRANCH - show dependent code
Package BodyOE_1019PC2_LINE_CANLINE - show dependent code
Package BodyOE_1019PC2_LINE_CLOSED - show dependent code
Package BodyOE_1019PC2_LINE_CRTSUP - show dependent code
Package BodyOE_1019PC2_LINE_ECSUPDT - show dependent code
Package BodyOE_1019PC2_LINE_ENTER - show dependent code
Package BodyOE_1019PC2_LINE_EXPCOMP - show dependent code
Package BodyOE_1019PC2_LINE_EXTLINE - show dependent code
Package BodyOE_1019PC2_LINE_FULFILL - show dependent code
Package BodyOE_1019PC2_LINE_INCITEM - show dependent code
Package BodyOE_1019PC2_LINE_INVIFAC - show dependent code
Package BodyOE_1019PC2_LINE_INVOICE - show dependent code
Package BodyOE_1019PC2_LINE_ISOL - show dependent code
Package BodyOE_1019PC2_LINE_NAINV - show dependent code
Package BodyOE_1019PC2_LINE_PRCONF - show dependent code
Package BodyOE_1019PC2_LINE_PURREL - show dependent code
Package BodyOE_1019PC2_LINE_RCVED - show dependent code
Package BodyOE_1019PC2_LINE_REGLINE - show dependent code
Package BodyOE_1019PC2_LINE_RETLIN - show dependent code
Package BodyOE_1019PC2_LINE_RETROLN - show dependent code
Package BodyOE_1019PC2_LINE_RLMLIN - show dependent code
Package BodyOE_1019PC2_LINE_RTLAPVD - show dependent code
Package BodyOE_1019PC2_LINE_RTLREJD - show dependent code
Package BodyOE_1019PC2_LINE_SCHEXST - show dependent code
Package BodyOE_1019PC2_LINE_SERVICE - show dependent code
Package BodyOE_1019PC2_LINE_SHIPA - show dependent code
Package BodyOE_1019PC2_LINE_SHIPC - show dependent code
Package BodyOE_1019PC2_LINE_SHPCNF - show dependent code
Package BodyOE_1019PC2_LINE_STANDAR - show dependent code
Package BodyOE_BLANKET_LINE_SECURITY - show dependent code
PL/SQL PackageOE_BLANKET_LINE_SECURITY - show dependent code
PL/SQL PackageOE_BLANKET_UTIL - show dependent code
Package BodyOE_BLANKET_UTIL - show dependent code
PL/SQL PackageONT_BLANKET_LINE_DEF_UTIL - show dependent code
Package BodyONT_BLANKET_LINE_DEF_UTIL - show dependent code