Skip to content

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

TABLE: ONT.OE_BLANKET_LINES_HIST

Object Details
Object Name: OE_BLANKET_LINES_HIST
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_BLANKET_LINES_HIST
Subobject Name:
Status: VALID


Primary for storing Revisions.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_BLANKET_LINES_HIST_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
ColumnHIST_TYPE_CODE
OE_BLANKET_LINES_HIST_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_PO_NUMBER
OE_BLANKET_LINES_HIST_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHIST_CREATION_DATE
ColumnLINE_ID
OE_BLANKET_LINES_HIST_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
ColumnVERSION_NUMBER
OE_BLANKET_LINES_HIST_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_NUMBER
ColumnLINE_NUMBER
ColumnVERSION_NUMBER
OE_BLANKET_LINES_HIST_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSTART_DATE_ACTIVE
OE_BLANKET_LINES_HIST_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEND_DATE_ACTIVE
OE_BLANKET_LINES_HIST_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_TO_ORG_ID
OE_BLANKET_LINES_HIST_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER

System Generated Line Identifier
ORG_ID NUMBER

Operating Unit which performed this transaction
HEADER_ID NUMBER

Foreign Key reference to OE_BLANKET_HEADERS_HIST
LINE_TYPE_ID NUMBER

Not Used deprecated
LINE_NUMBER NUMBER

Line sequence number within the sales agreement
REQUEST_DATE DATE

Not Used deprecated
PROMISE_DATE DATE

Not Used deprecated
SCHEDULE_SHIP_DATE DATE

Not Used deprecated
ORDER_QUANTITY_UOM VARCHAR2 (3)
Sales Agreement Quantity Unit of Measure
PRICING_QUANTITY NUMBER

Not Used deprecated
PRICING_QUANTITY_UOM VARCHAR2 (3)
Not Used deprecated
CANCELLED_QUANTITY NUMBER

Not Used deprecated
SHIPPED_QUANTITY NUMBER

Not Used deprecated
ORDERED_QUANTITY NUMBER

Not Used deprecated
FULFILLED_QUANTITY NUMBER

Fulfilled Quantity
SHIPPING_QUANTITY NUMBER

Not Used deprecated
SHIPPING_QUANTITY_UOM VARCHAR2 (3)
Not Used deprecated
DELIVERY_LEAD_TIME NUMBER

Not Used deprecated
TAX_EXEMPT_FLAG VARCHAR2 (1)
Not Used deprecated
TAX_EXEMPT_NUMBER VARCHAR2 (80)
Not Used deprecated
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
Not Used deprecated
SHIP_FROM_ORG_ID NUMBER

Ship from Organization ID - warehouse
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_TO_CONTACT_ID NUMBER

Not Used deprecated
DELIVER_TO_CONTACT_ID NUMBER

Not Used deprecated
INVOICE_TO_CONTACT_ID NUMBER

Not Used deprecated
SOLD_FROM_ORG_ID NUMBER

Not Used deprecated
SOLD_TO_ORG_ID NUMBER

Customer to whom the item is Sold To
CUST_PO_NUMBER VARCHAR2 (50)
Customer Purchase Order Number
SHIP_TOLERANCE_ABOVE NUMBER

Not Used deprecated
SHIP_TOLERANCE_BELOW NUMBER

Not Used deprecated
DEMAND_BUCKET_TYPE_CODE VARCHAR2 (30)
Not Used deprecated
VEH_CUS_ITEM_CUM_KEY_ID NUMBER

Not Used deprecated
RLA_SCHEDULE_TYPE_CODE VARCHAR2 (30)
Not Used deprecated
CUSTOMER_DOCK_CODE VARCHAR2 (50)
Not Used deprecated
CUSTOMER_JOB VARCHAR2 (50)
Not Used deprecated
CUSTOMER_PRODUCTION_LINE VARCHAR2 (50)
Not Used deprecated
CUST_MODEL_SERIAL_NUMBER VARCHAR2 (50)
Not Used deprecated
PROJECT_ID NUMBER

Not Used deprecated
TASK_ID NUMBER

Not Used deprecated
INVENTORY_ITEM_ID NUMBER

Inventory Item Id
TAX_DATE DATE

Not Used deprecated
TAX_CODE VARCHAR2 (50)
Not Used deprecated
TAX_RATE NUMBER

Not Used deprecated
DEMAND_CLASS_CODE VARCHAR2 (30)
Not Used deprecated
PRICE_LIST_ID NUMBER

Price List
PRICING_DATE DATE

Not Used deprecated
SHIPMENT_NUMBER NUMBER

System generated identifier of a shipment within a line
AGREEMENT_ID NUMBER

Internal Use only
SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
Not Used deprecated
SHIPPING_METHOD_CODE VARCHAR2 (30)
Shipping Method
FREIGHT_CARRIER_CODE VARCHAR2 (30)
Not Used deprecated
FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight Terms, specifying the responsibility for freight.
FOB_POINT_CODE VARCHAR2 (30)
Not Used deprecated
TAX_POINT_CODE VARCHAR2 (30)
Not Used deprecated
PAYMENT_TERM_ID NUMBER

Payment Terms
INVOICING_RULE_ID NUMBER

Invoicing rule used by AR, for generating Invoice
ACCOUNTING_RULE_ID NUMBER

Accounting Rule used by AR, for generating Invoice.
SOURCE_DOCUMENT_TYPE_ID NUMBER

Indicates the source of the sales agreement
ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
Not Used deprecated
SOURCE_DOCUMENT_ID NUMBER

Source Sales Agreement Header ID
ORIG_SYS_LINE_REF VARCHAR2 (50)
Not Used deprecated
SOURCE_DOCUMENT_LINE_ID NUMBER

Source Sales Agreement Line Id
REFERENCE_LINE_ID NUMBER

Not Used deprecated
REFERENCE_TYPE VARCHAR2 (30)
Not Used deprecated
REFERENCE_HEADER_ID NUMBER

Not Used deprecated
ITEM_REVISION VARCHAR2 (3)
Not Used deprecated
UNIT_SELLING_PRICE NUMBER

Not Used deprecated
UNIT_LIST_PRICE NUMBER

Not Used deprecated
TAX_VALUE NUMBER

Not Used deprecated
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
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality.
ATTRIBUTE18 VARCHAR2 (240)
Descriptive Flexfield Segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE1 VARCHAR2 (240)
Reserved for country-specific functionality.
ATTRIBUTE20 VARCHAR2 (240)
Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE2 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE3 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE4 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE5 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE6 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE7 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE8 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE9 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE10 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE11 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE12 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE13 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE14 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE15 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE16 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE17 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE18 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE19 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE20 VARCHAR2 (240)
Reserved for country-specific functionality.
PRICING_CONTEXT VARCHAR2 (30)
Descriptive Flexfield Segment
PRICING_ATTRIBUTE1 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
PRICING_ATTRIBUTE2 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
PRICING_ATTRIBUTE3 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
PRICING_ATTRIBUTE4 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
PRICING_ATTRIBUTE5 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
PRICING_ATTRIBUTE6 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
PRICING_ATTRIBUTE7 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
PRICING_ATTRIBUTE8 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
PRICING_ATTRIBUTE9 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
PRICING_ATTRIBUTE10 VARCHAR2 (240)
Pricing related Descriptive Flexfield Segment.
INDUSTRY_CONTEXT VARCHAR2 (30)
Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE1 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE2 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE3 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE4 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE5 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE6 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE7 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE8 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE9 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE10 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE11 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE13 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE12 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE14 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE15 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE16 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE17 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE18 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE19 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE20 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE21 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE22 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE23 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE24 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE25 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE26 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE27 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE28 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE29 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
INDUSTRY_ATTRIBUTE30 VARCHAR2 (240)
Industry Specific Descriptive Flexfield Segment
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
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
REQUEST_ID NUMBER

Not Used deprecated
CONFIGURATION_ID NUMBER

Not Used deprecated
COMPONENT_SEQUENCE_ID NUMBER

Not Used deprecated
COMPONENT_CODE VARCHAR2 (1000)
Not Used deprecated
CONFIG_DISPLAY_SEQUENCE NUMBER

Not Used deprecated
SORT_ORDER VARCHAR2 (240)
Not used deprecated
ITEM_TYPE_CODE VARCHAR2 (30)
Type of Item
OPTION_NUMBER NUMBER

Not Used deprecated
OPTION_FLAG VARCHAR2 (1)
Not Used deprecated
DEP_PLAN_REQUIRED_FLAG VARCHAR2 (1)
Not Used deprecated
VISIBLE_DEMAND_FLAG VARCHAR2 (1)
Not Used deprecated
LINE_CATEGORY_CODE VARCHAR2 (30)
Indicates whether the line is regular or return.
ACTUAL_SHIPMENT_DATE DATE

Not Used deprecated
CUSTOMER_TRX_LINE_ID NUMBER

Not Used deprecated
RETURN_CONTEXT VARCHAR2 (30)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE1 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE2 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE3 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE4 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE5 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE6 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE7 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE8 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE9 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE10 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE11 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE12 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE13 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE14 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
RETURN_ATTRIBUTE15 VARCHAR2 (240)
Return Specific Descriptive Flexfield Segment
INTMED_SHIP_TO_ORG_ID NUMBER

Not Used deprecated
INTMED_SHIP_TO_CONTACT_ID NUMBER

Not Used deprecated
ACTUAL_ARRIVAL_DATE DATE

Not Used deprecated
ATO_LINE_ID NUMBER

Not Used deprecated
AUTO_SELECTED_QUANTITY NUMBER

Not Used deprecated
COMPONENT_NUMBER NUMBER

Not Used deprecated
EARLIEST_ACCEPTABLE_DATE DATE

Not Used deprecated
EXPLOSION_DATE DATE

Not Used deprecated
LATEST_ACCEPTABLE_DATE DATE

Not Used deprecated
MODEL_GROUP_NUMBER NUMBER

Not Used deprecated
SCHEDULE_ARRIVAL_DATE DATE

Not Used deprecated
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
Not Used deprecated
SCHEDULE_STATUS_CODE VARCHAR2 (30)
Not Used deprecated
SOURCE_TYPE_CODE VARCHAR2 (30)
Not used deprecated
TOP_MODEL_LINE_ID NUMBER

Not Used deprecated
BOOKED_FLAG VARCHAR2 (1)
Not Used deprecated
CANCELLED_FLAG VARCHAR2 (1)
Not Used deprecated
OPEN_FLAG VARCHAR2 (1)
Not Used deprecated
LOAD_SEQ_NUMBER NUMBER

Not Used deprecated
DELIVERY_ID NUMBER

Not Used deprecated
SALESREP_ID NUMBER (15)
Sales Person Identifier
RETURN_REASON_CODE VARCHAR2 (30)
Not Used deprecated
WF_ACTIVITY_CODE VARCHAR2 (50)
Not Used deprecated
WF_RESULT_CODE VARCHAR2 (50)
Not Used deprecated
REASON_CODE VARCHAR2 (30)
Not used deprecated
HIST_COMMENTS VARCHAR2 (2000)
Not Used deprecated
HIST_TYPE_CODE VARCHAR2 (30) Yes Not Used deprecated
HIST_CREATION_DATE DATE

Not Used deprecated
HIST_CREATED_BY NUMBER

Not Used deprecated
CUST_PRODUCTION_SEQ_NUM VARCHAR2 (50)
Not Used deprecated
AUTHORIZED_TO_SHIP_FLAG VARCHAR2 (1)
Not Used deprecated
SPLIT_FROM_LINE_ID NUMBER

Not Used deprecated
OVER_SHIP_REASON_CODE VARCHAR2 (30)
Not Used deprecated
OVER_SHIP_RESOLVED_FLAG VARCHAR2 (1)
Not Used deprecated
ITEM_IDENTIFIER_TYPE VARCHAR2 (25)
To distinguish between different types of items (intrenal/custom)
ARRIVAL_SET_ID NUMBER

Not Used deprecated
SHIP_SET_ID NUMBER

Not Used deprecated
COMMITMENT_ID NUMBER

Not Used deprecated
SHIPPING_INTERFACED_FLAG VARCHAR2 (1)
Not Used deprecated
CREDIT_INVOICE_LINE_ID NUMBER

Not Used deprecated
MFG_COMPONENT_SEQUENCE_ID NUMBER

Not Used deprecated
TP_CONTEXT VARCHAR2 (30)
Descriptive Flexfield Segment
TP_ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield Segment
TP_ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield Segment
FULFILLMENT_METHOD_CODE VARCHAR2 (30)
Fulfillment method code
SERVICE_REFERENCE_TYPE_CODE VARCHAR2 (30)
Not Used deprecated
SERVICE_REFERENCE_LINE_ID NUMBER

Not Used deprecated
SERVICE_REFERENCE_SYSTEM_ID NUMBER

Not used deprecated
INVOICE_INTERFACE_STATUS_CODE VARCHAR2 (30)
Not Used deprecated
ORDERED_ITEM VARCHAR2 (2000)
Not Used deprecated
ORDERED_ITEM_ID NUMBER

Stores ID of the Sales Agreement Item
SERVICE_NUMBER NUMBER

Not Used deprecated
SERVICED_LINE_ID NUMBER

Not Used deprecated
SERVICE_DURATION NUMBER

Not Used deprecated
SERVICE_START_DATE DATE

Not Used deprecated
RE_SOURCE_FLAG VARCHAR2 (1)
Not used deprecated
FLOW_STATUS_CODE VARCHAR2 (30)
Workflow status for the Line
SERVICE_END_DATE DATE

Not Used deprecated
SERVICE_COTERMINATE_FLAG VARCHAR2 (1)
Not Used deprecated
SHIPPABLE_FLAG VARCHAR2 (1)
Not Used deprecated
ORDER_SOURCE_ID NUMBER

Not Used deprecated
ORIG_SYS_SHIPMENT_REF VARCHAR2 (50)
Not Used deprecated
CHANGE_SEQUENCE VARCHAR2 (50)
Not Used deprecated
DROP_SHIP_FLAG VARCHAR2 (1)
Not Used deprecated
CUSTOMER_LINE_NUMBER VARCHAR2 (50)
Not Used deprecated
CUSTOMER_SHIPMENT_NUMBER VARCHAR2 (50)
Not Used deprecated
CUSTOMER_ITEM_NET_PRICE NUMBER

Not Used deprecated
CUSTOMER_PAYMENT_TERM_ID NUMBER

Not Used deprecated
FIRST_ACK_DATE DATE

Not Used deprecated
FIRST_ACK_CODE VARCHAR2 (30)
Not Used deprecated
LAST_ACK_CODE VARCHAR2 (30)
Not Used deprecated
LAST_ACK_DATE DATE

Not Used deprecated
PLANNING_PRIORITY NUMBER

Not Used deprecated
SERVICE_TXN_COMMENTS VARCHAR2 (2000)
Not Used deprecated
SERVICE_PERIOD VARCHAR2 (3)
Not Used deprecated
UNIT_SELLING_PERCENT NUMBER

Not Used deprecated
UNIT_LIST_PERCENT NUMBER

Not Used deprecated
UNIT_PERCENT_BASE_PRICE NUMBER

Not Used deprecated
MODEL_REMNANT_FLAG VARCHAR2 (1)
Not Used deprecated
SERVICE_TXN_REASON_CODE VARCHAR2 (30)
Not Used deprecated
CALCULATE_PRICE_FLAG VARCHAR2 (1)
Not Used deprecated
ITEM_INPUT VARCHAR2 (2000)
Not Used deprecated
CUSTOMER_ITEM_ID NUMBER

Not Used deprecated
CUSTOMER_ITEM_REVISION VARCHAR2 (50)
Not Used deprecated
ITEM_ID NUMBER

Not Used deprecated
INVOICE_COMPLETE_FLAG VARCHAR2 (1)
Not Used deprecated
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Not Used deprecated
FULFILLED_FLAG VARCHAR2 (1)
Not Used deprecated
CONFIG_HEADER_ID NUMBER

Not Used deprecated
CONFIG_REV_NBR NUMBER

Not Used deprecated
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Sjipping Instructions for Line
PACKING_INSTRUCTIONS VARCHAR2 (2000)
Packing Instructions for Line
INVOICED_QUANTITY NUMBER

Not Used deprecated
REFERENCE_CUSTOMER_TRX_LINE_ID NUMBER

Not Used deprecated
SPLIT_BY VARCHAR2 (30)
Not Used deprecated
LINE_SET_ID NUMBER

Not Used deprecated
REVENUE_AMOUNT NUMBER

Not Used deprecated
FULFILLMENT_DATE DATE

Not Used deprecated
PREFERRED_GRADE VARCHAR2 (150)
Grade requested by the customer
ORDERED_QUANTITY2 NUMBER

Not Used deprecated
ORDERED_QUANTITY_UOM2 VARCHAR2 (3)
Not Used deprecated
SHIPPED_QUANTITY2 NUMBER

Not Used deprecated
CANCELLED_QUANTITY2 NUMBER

Not Used deprecated
SHIPPING_QUANTITY2 NUMBER

Not Used deprecated
SHIPPING_QUANTITY_UOM2 VARCHAR2 (3)
Not Used deprecated
FULFILLED_QUANTITY2 NUMBER

Not Used deprecated
SUBINVENTORY VARCHAR2 (10)
Not Used deprecated
RESPONSIBILITY_ID NUMBER

Not Used deprecated
UNIT_LIST_PRICE_PER_PQTY NUMBER

Not Used deprecated
UNIT_SELLING_PRICE_PER_PQTY NUMBER

Not Used deprecated
LATEST_CANCELLED_QUANTITY NUMBER

Not Used deprecated
PRICE_REQUEST_CODE VARCHAR2 (240)
Not Used deprecated
LATE_DEMAND_PENALTY_FACTOR NUMBER

Not Used deprecated
OVERRIDE_ATP_DATE_CODE VARCHAR2 (30)
Not Used deprecated
ITEM_SUBSTITUTION_TYPE_CODE VARCHAR2 (30)
Not Used deprecated
ORIGINAL_ITEM_IDENTIFIER_TYPE VARCHAR2 (30)
Not Used deprecated
ORIGINAL_ORDERED_ITEM VARCHAR2 (2000)
Not Used deprecated
ORIGINAL_ORDERED_ITEM_ID NUMBER

Not Used deprecated
ORIGINAL_INVENTORY_ITEM_ID NUMBER

Not Used deprecated
ACCOUNTING_RULE_DURATION NUMBER (15)
Not Used deprecated
USER_ITEM_DESCRIPTION VARCHAR2 (1000)
Not Used deprecated
ITEM_RELATIONSHIP_TYPE NUMBER

Not Used deprecated
BLANKET_LINE_NUMBER NUMBER

Not Used deprecated
BLANKET_VERSION_NUMBER NUMBER

Not Used deprecated
BLANKET_NUMBER NUMBER

Not Used deprecated
VERSION_NUMBER NUMBER

Revision Number of the sales agreement
START_DATE_ACTIVE DATE

Activation date of Sales Agreement Line
END_DATE_ACTIVE DATE

Expiration Date of Sales Agreement Line
BLANKET_LINE_MAX_AMOUNT NUMBER

Maximum total currency amount allowed
BLANKET_LINE_MIN_AMOUNT NUMBER

Minimum total currency amount allowed
ENFORCE_PRICE_LIST_FLAG VARCHAR2 (1)
Enforces Price List on Release Line
RELEASED_AMOUNT NUMBER

Current released currency amount
RETURNED_AMOUNT NUMBER

Current Returned currency amount
MAX_RELEASE_AMOUNT NUMBER

Maximum release currency amount allowed.
MIN_RELEASE_AMOUNT NUMBER

Minimum release currency amount allowed.
BLANKET_MAX_QUANTITY NUMBER

Maximum total quantity allowed
BLANKET_MIN_QUANTITY NUMBER

Minimum total quantity allowed
MAX_RELEASE_QUANTITY NUMBER

Maximum Release Quantity
MIN_RELEASE_QUANTITY NUMBER

Minimum Release Quantity
OVERRIDE_RELEASE_CONTROLS_FLAG VARCHAR2 (1)
Allow Override of min/max of release values.
OVERRIDE_BLANKET_CONTROLS_FLAG VARCHAR2 (1)
Allow Override of min/max values.
RETURNED_QUANTITY NUMBER

Current Returned quanity
RELEASED_QUANTITY NUMBER

Current Released Quantity.
QP_LIST_LINE_ID NUMBER

Foreign Key reference to QP_LIST_LINES_VL the price list.
ORDER_NUMBER NUMBER

Foreign Key references to OE_BLANKET_LINES_ALL
ENFORCE_ACCOUNTING_RULE_FLAG VARCHAR2 (1) Yes Enforces Accounting Rule on Release Line.
ENFORCE_INVOICING_RULE_FLAG VARCHAR2 (1) Yes Enforces Invoicing Rule on Release Line
ENFORCE_SHIP_TO_FLAG VARCHAR2 (1) Yes Enforces Ship To on Release Line
ENFORCE_INVOICE_TO_FLAG VARCHAR2 (1) Yes Enforces Invoice To on Release Line
ENFORCE_FREIGHT_TERM_FLAG VARCHAR2 (1) Yes Enforces Freight Term on Release Line
ENFORCE_SHIPPING_METHOD_FLAG VARCHAR2 (1) Yes Enforces Shipping Method on Release Line
ENFORCE_PAYMENT_TERM_FLAG VARCHAR2 (1) Yes Enforces Payment Term on Release Line
SALES_DOCUMENT_TYPE_CODE VARCHAR2 (30)
For Future Release
FULFILLED_AMOUNT NUMBER

Current Fulfilled currency amount
TRANSACTION_PHASE_CODE VARCHAR2 (30)
Indicates if Transaction is in negotitation or fulfillment phase
SOURCE_DOCUMENT_VERSION_NUMBER NUMBER

Internal Use Only.
MODIFIER_LIST_LINE_ID NUMBER

Identifier for discount line created inline from this sales agreement line
AUDIT_FLAG VARCHAR2 (1)
Audit Flag
VERSION_FLAG VARCHAR2 (1)
Version Flag
PHASE_CHANGE_FLAG VARCHAR2 (1)
Indicates phase change to transaction
REASON_ID NUMBER

Reason Id
ORDER_FIRMED_DATE DATE

Demand firm date
ACTUAL_FULFILLMENT_DATE DATE

Date the line was fulfilled
INST_ID NUMBER

RAC INSTANCE AFFINITY for context setting
Query Text

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


SELECT LINE_ID
,      ORG_ID
,      HEADER_ID
,      LINE_TYPE_ID
,      LINE_NUMBER
,      REQUEST_DATE
,      PROMISE_DATE
,      SCHEDULE_SHIP_DATE
,      ORDER_QUANTITY_UOM
,      PRICING_QUANTITY
,      PRICING_QUANTITY_UOM
,      CANCELLED_QUANTITY
,      SHIPPED_QUANTITY
,      ORDERED_QUANTITY
,      FULFILLED_QUANTITY
,      SHIPPING_QUANTITY
,      SHIPPING_QUANTITY_UOM
,      DELIVERY_LEAD_TIME
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      INVOICE_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      SHIP_TO_CONTACT_ID
,      DELIVER_TO_CONTACT_ID
,      INVOICE_TO_CONTACT_ID
,      SOLD_FROM_ORG_ID
,      SOLD_TO_ORG_ID
,      CUST_PO_NUMBER
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      DEMAND_BUCKET_TYPE_CODE
,      VEH_CUS_ITEM_CUM_KEY_ID
,      RLA_SCHEDULE_TYPE_CODE
,      CUSTOMER_DOCK_CODE
,      CUSTOMER_JOB
,      CUSTOMER_PRODUCTION_LINE
,      CUST_MODEL_SERIAL_NUMBER
,      PROJECT_ID
,      TASK_ID
,      INVENTORY_ITEM_ID
,      TAX_DATE
,      TAX_CODE
,      TAX_RATE
,      DEMAND_CLASS_CODE
,      PRICE_LIST_ID
,      PRICING_DATE
,      SHIPMENT_NUMBER
,      AGREEMENT_ID
,      SHIPMENT_PRIORITY_CODE
,      SHIPPING_METHOD_CODE
,      FREIGHT_CARRIER_CODE
,      FREIGHT_TERMS_CODE
,      FOB_POINT_CODE
,      TAX_POINT_CODE
,      PAYMENT_TERM_ID
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      ORIG_SYS_DOCUMENT_REF
,      SOURCE_DOCUMENT_ID
,      ORIG_SYS_LINE_REF
,      SOURCE_DOCUMENT_LINE_ID
,      REFERENCE_LINE_ID
,      REFERENCE_TYPE
,      REFERENCE_HEADER_ID
,      ITEM_REVISION
,      UNIT_SELLING_PRICE
,      UNIT_LIST_PRICE
,      TAX_VALUE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      GLOBAL_ATTRIBUTE_CATEGORY
,      ATTRIBUTE18
,      ATTRIBUTE19
,      GLOBAL_ATTRIBUTE1
,      ATTRIBUTE20
,      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
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      INDUSTRY_CONTEXT
,      INDUSTRY_ATTRIBUTE1
,      INDUSTRY_ATTRIBUTE2
,      INDUSTRY_ATTRIBUTE3
,      INDUSTRY_ATTRIBUTE4
,      INDUSTRY_ATTRIBUTE5
,      INDUSTRY_ATTRIBUTE6
,      INDUSTRY_ATTRIBUTE7
,      INDUSTRY_ATTRIBUTE8
,      INDUSTRY_ATTRIBUTE9
,      INDUSTRY_ATTRIBUTE10
,      INDUSTRY_ATTRIBUTE11
,      INDUSTRY_ATTRIBUTE13
,      INDUSTRY_ATTRIBUTE12
,      INDUSTRY_ATTRIBUTE14
,      INDUSTRY_ATTRIBUTE15
,      INDUSTRY_ATTRIBUTE16
,      INDUSTRY_ATTRIBUTE17
,      INDUSTRY_ATTRIBUTE18
,      INDUSTRY_ATTRIBUTE19
,      INDUSTRY_ATTRIBUTE20
,      INDUSTRY_ATTRIBUTE21
,      INDUSTRY_ATTRIBUTE22
,      INDUSTRY_ATTRIBUTE23
,      INDUSTRY_ATTRIBUTE24
,      INDUSTRY_ATTRIBUTE25
,      INDUSTRY_ATTRIBUTE26
,      INDUSTRY_ATTRIBUTE27
,      INDUSTRY_ATTRIBUTE28
,      INDUSTRY_ATTRIBUTE29
,      INDUSTRY_ATTRIBUTE30
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CONFIGURATION_ID
,      LINK_TO_LINE_ID
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_CODE
,      CONFIG_DISPLAY_SEQUENCE
,      SORT_ORDER
,      ITEM_TYPE_CODE
,      OPTION_NUMBER
,      OPTION_FLAG
,      DEP_PLAN_REQUIRED_FLAG
,      VISIBLE_DEMAND_FLAG
,      LINE_CATEGORY_CODE
,      ACTUAL_SHIPMENT_DATE
,      CUSTOMER_TRX_LINE_ID
,      RETURN_CONTEXT
,      RETURN_ATTRIBUTE1
,      RETURN_ATTRIBUTE2
,      RETURN_ATTRIBUTE3
,      RETURN_ATTRIBUTE4
,      RETURN_ATTRIBUTE5
,      RETURN_ATTRIBUTE6
,      RETURN_ATTRIBUTE7
,      RETURN_ATTRIBUTE8
,      RETURN_ATTRIBUTE9
,      RETURN_ATTRIBUTE10
,      RETURN_ATTRIBUTE11
,      RETURN_ATTRIBUTE12
,      RETURN_ATTRIBUTE13
,      RETURN_ATTRIBUTE14
,      RETURN_ATTRIBUTE15
,      INTMED_SHIP_TO_ORG_ID
,      INTMED_SHIP_TO_CONTACT_ID
,      ACTUAL_ARRIVAL_DATE
,      ATO_LINE_ID
,      AUTO_SELECTED_QUANTITY
,      COMPONENT_NUMBER
,      EARLIEST_ACCEPTABLE_DATE
,      EXPLOSION_DATE
,      LATEST_ACCEPTABLE_DATE
,      MODEL_GROUP_NUMBER
,      SCHEDULE_ARRIVAL_DATE
,      SHIP_MODEL_COMPLETE_FLAG
,      SCHEDULE_STATUS_CODE
,      SOURCE_TYPE_CODE
,      TOP_MODEL_LINE_ID
,      BOOKED_FLAG
,      CANCELLED_FLAG
,      OPEN_FLAG
,      LOAD_SEQ_NUMBER
,      DELIVERY_ID
,      SALESREP_ID
,      RETURN_REASON_CODE
,      WF_ACTIVITY_CODE
,      WF_RESULT_CODE
,      REASON_CODE
,      HIST_COMMENTS
,      HIST_TYPE_CODE
,      HIST_CREATION_DATE
,      HIST_CREATED_BY
,      CUST_PRODUCTION_SEQ_NUM
,      AUTHORIZED_TO_SHIP_FLAG
,      SPLIT_FROM_LINE_ID
,      OVER_SHIP_REASON_CODE
,      OVER_SHIP_RESOLVED_FLAG
,      ITEM_IDENTIFIER_TYPE
,      ARRIVAL_SET_ID
,      SHIP_SET_ID
,      COMMITMENT_ID
,      SHIPPING_INTERFACED_FLAG
,      CREDIT_INVOICE_LINE_ID
,      MFG_COMPONENT_SEQUENCE_ID
,      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
,      FULFILLMENT_METHOD_CODE
,      SERVICE_REFERENCE_TYPE_CODE
,      SERVICE_REFERENCE_LINE_ID
,      SERVICE_REFERENCE_SYSTEM_ID
,      INVOICE_INTERFACE_STATUS_CODE
,      ORDERED_ITEM
,      ORDERED_ITEM_ID
,      SERVICE_NUMBER
,      SERVICED_LINE_ID
,      SERVICE_DURATION
,      SERVICE_START_DATE
,      RE_SOURCE_FLAG
,      FLOW_STATUS_CODE
,      SERVICE_END_DATE
,      SERVICE_COTERMINATE_FLAG
,      SHIPPABLE_FLAG
,      ORDER_SOURCE_ID
,      ORIG_SYS_SHIPMENT_REF
,      CHANGE_SEQUENCE
,      DROP_SHIP_FLAG
,      CUSTOMER_LINE_NUMBER
,      CUSTOMER_SHIPMENT_NUMBER
,      CUSTOMER_ITEM_NET_PRICE
,      CUSTOMER_PAYMENT_TERM_ID
,      FIRST_ACK_DATE
,      FIRST_ACK_CODE
,      LAST_ACK_CODE
,      LAST_ACK_DATE
,      PLANNING_PRIORITY
,      SERVICE_TXN_COMMENTS
,      SERVICE_PERIOD
,      UNIT_SELLING_PERCENT
,      UNIT_LIST_PERCENT
,      UNIT_PERCENT_BASE_PRICE
,      MODEL_REMNANT_FLAG
,      SERVICE_TXN_REASON_CODE
,      CALCULATE_PRICE_FLAG
,      ITEM_INPUT
,      CUSTOMER_ITEM_ID
,      CUSTOMER_ITEM_REVISION
,      ITEM_ID
,      INVOICE_COMPLETE_FLAG
,      END_ITEM_UNIT_NUMBER
,      FULFILLED_FLAG
,      CONFIG_HEADER_ID
,      CONFIG_REV_NBR
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      INVOICED_QUANTITY
,      REFERENCE_CUSTOMER_TRX_LINE_ID
,      SPLIT_BY
,      LINE_SET_ID
,      REVENUE_AMOUNT
,      FULFILLMENT_DATE
,      PREFERRED_GRADE
,      ORDERED_QUANTITY2
,      ORDERED_QUANTITY_UOM2
,      SHIPPED_QUANTITY2
,      CANCELLED_QUANTITY2
,      SHIPPING_QUANTITY2
,      SHIPPING_QUANTITY_UOM2
,      FULFILLED_QUANTITY2
,      SUBINVENTORY
,      RESPONSIBILITY_ID
,      UNIT_LIST_PRICE_PER_PQTY
,      UNIT_SELLING_PRICE_PER_PQTY
,      LATEST_CANCELLED_QUANTITY
,      PRICE_REQUEST_CODE
,      LATE_DEMAND_PENALTY_FACTOR
,      OVERRIDE_ATP_DATE_CODE
,      ITEM_SUBSTITUTION_TYPE_CODE
,      ORIGINAL_ITEM_IDENTIFIER_TYPE
,      ORIGINAL_ORDERED_ITEM
,      ORIGINAL_ORDERED_ITEM_ID
,      ORIGINAL_INVENTORY_ITEM_ID
,      ACCOUNTING_RULE_DURATION
,      USER_ITEM_DESCRIPTION
,      ITEM_RELATIONSHIP_TYPE
,      BLANKET_LINE_NUMBER
,      BLANKET_VERSION_NUMBER
,      BLANKET_NUMBER
,      VERSION_NUMBER
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      BLANKET_LINE_MAX_AMOUNT
,      BLANKET_LINE_MIN_AMOUNT
,      ENFORCE_PRICE_LIST_FLAG
,      RELEASED_AMOUNT
,      RETURNED_AMOUNT
,      MAX_RELEASE_AMOUNT
,      MIN_RELEASE_AMOUNT
,      BLANKET_MAX_QUANTITY
,      BLANKET_MIN_QUANTITY
,      MAX_RELEASE_QUANTITY
,      MIN_RELEASE_QUANTITY
,      OVERRIDE_RELEASE_CONTROLS_FLAG
,      OVERRIDE_BLANKET_CONTROLS_FLAG
,      RETURNED_QUANTITY
,      RELEASED_QUANTITY
,      QP_LIST_LINE_ID
,      ORDER_NUMBER
,      ENFORCE_ACCOUNTING_RULE_FLAG
,      ENFORCE_INVOICING_RULE_FLAG
,      ENFORCE_SHIP_TO_FLAG
,      ENFORCE_INVOICE_TO_FLAG
,      ENFORCE_FREIGHT_TERM_FLAG
,      ENFORCE_SHIPPING_METHOD_FLAG
,      ENFORCE_PAYMENT_TERM_FLAG
,      SALES_DOCUMENT_TYPE_CODE
,      FULFILLED_AMOUNT
,      TRANSACTION_PHASE_CODE
,      SOURCE_DOCUMENT_VERSION_NUMBER
,      MODIFIER_LIST_LINE_ID
,      AUDIT_FLAG
,      VERSION_FLAG
,      PHASE_CHANGE_FLAG
,      REASON_ID
,      ORDER_FIRMED_DATE
,      ACTUAL_FULFILLMENT_DATE
,      INST_ID
FROM ONT.OE_BLANKET_LINES_HIST;

Dependencies

[top of page]

ONT.OE_BLANKET_LINES_HIST does not reference any database object

ONT.OE_BLANKET_LINES_HIST is referenced by following:

SchemaONT
ViewOE_BLANKET_LINES_HIST#