Skip to content

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

VIEW: ONT.OE_BLANKET_LINES_HIST#

Object Details
Object Name: OE_BLANKET_LINES_HIST#
Object Type: VIEW
Owner: ONT
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER

ORG_ID NUMBER

HEADER_ID NUMBER

LINE_TYPE_ID NUMBER

LINE_NUMBER NUMBER

REQUEST_DATE DATE

PROMISE_DATE DATE

SCHEDULE_SHIP_DATE DATE

ORDER_QUANTITY_UOM VARCHAR2 (3)
PRICING_QUANTITY NUMBER

PRICING_QUANTITY_UOM VARCHAR2 (3)
CANCELLED_QUANTITY NUMBER

SHIPPED_QUANTITY NUMBER

ORDERED_QUANTITY NUMBER

FULFILLED_QUANTITY NUMBER

SHIPPING_QUANTITY NUMBER

SHIPPING_QUANTITY_UOM VARCHAR2 (3)
DELIVERY_LEAD_TIME NUMBER

TAX_EXEMPT_FLAG VARCHAR2 (1)
TAX_EXEMPT_NUMBER VARCHAR2 (80)
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
SHIP_FROM_ORG_ID NUMBER

SHIP_TO_ORG_ID NUMBER

INVOICE_TO_ORG_ID NUMBER

DELIVER_TO_ORG_ID NUMBER

SHIP_TO_CONTACT_ID NUMBER

DELIVER_TO_CONTACT_ID NUMBER

INVOICE_TO_CONTACT_ID NUMBER

SOLD_FROM_ORG_ID NUMBER

SOLD_TO_ORG_ID NUMBER

CUST_PO_NUMBER VARCHAR2 (50)
SHIP_TOLERANCE_ABOVE NUMBER

SHIP_TOLERANCE_BELOW NUMBER

DEMAND_BUCKET_TYPE_CODE VARCHAR2 (30)
VEH_CUS_ITEM_CUM_KEY_ID NUMBER

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

TASK_ID NUMBER

INVENTORY_ITEM_ID NUMBER

TAX_DATE DATE

TAX_CODE VARCHAR2 (50)
TAX_RATE NUMBER

DEMAND_CLASS_CODE VARCHAR2 (30)
PRICE_LIST_ID NUMBER

PRICING_DATE DATE

SHIPMENT_NUMBER NUMBER

AGREEMENT_ID NUMBER

SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
SHIPPING_METHOD_CODE VARCHAR2 (30)
FREIGHT_CARRIER_CODE VARCHAR2 (30)
FREIGHT_TERMS_CODE VARCHAR2 (30)
FOB_POINT_CODE VARCHAR2 (30)
TAX_POINT_CODE VARCHAR2 (30)
PAYMENT_TERM_ID NUMBER

INVOICING_RULE_ID NUMBER

ACCOUNTING_RULE_ID NUMBER

SOURCE_DOCUMENT_TYPE_ID NUMBER

ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
SOURCE_DOCUMENT_ID NUMBER

ORIG_SYS_LINE_REF VARCHAR2 (50)
SOURCE_DOCUMENT_LINE_ID NUMBER

REFERENCE_LINE_ID NUMBER

REFERENCE_TYPE VARCHAR2 (30)
REFERENCE_HEADER_ID NUMBER

ITEM_REVISION VARCHAR2 (3)
UNIT_SELLING_PRICE NUMBER

UNIT_LIST_PRICE NUMBER

TAX_VALUE NUMBER

CONTEXT VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
ATTRIBUTE16 VARCHAR2 (240)
ATTRIBUTE17 VARCHAR2 (240)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE18 VARCHAR2 (240)
ATTRIBUTE19 VARCHAR2 (240)
GLOBAL_ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE20 VARCHAR2 (240)
GLOBAL_ATTRIBUTE2 VARCHAR2 (240)
GLOBAL_ATTRIBUTE3 VARCHAR2 (240)
GLOBAL_ATTRIBUTE4 VARCHAR2 (240)
GLOBAL_ATTRIBUTE5 VARCHAR2 (240)
GLOBAL_ATTRIBUTE6 VARCHAR2 (240)
GLOBAL_ATTRIBUTE7 VARCHAR2 (240)
GLOBAL_ATTRIBUTE8 VARCHAR2 (240)
GLOBAL_ATTRIBUTE9 VARCHAR2 (240)
GLOBAL_ATTRIBUTE10 VARCHAR2 (240)
GLOBAL_ATTRIBUTE11 VARCHAR2 (240)
GLOBAL_ATTRIBUTE12 VARCHAR2 (240)
GLOBAL_ATTRIBUTE13 VARCHAR2 (240)
GLOBAL_ATTRIBUTE14 VARCHAR2 (240)
GLOBAL_ATTRIBUTE15 VARCHAR2 (240)
GLOBAL_ATTRIBUTE16 VARCHAR2 (240)
GLOBAL_ATTRIBUTE17 VARCHAR2 (240)
GLOBAL_ATTRIBUTE18 VARCHAR2 (240)
GLOBAL_ATTRIBUTE19 VARCHAR2 (240)
GLOBAL_ATTRIBUTE20 VARCHAR2 (240)
PRICING_CONTEXT VARCHAR2 (30)
PRICING_ATTRIBUTE1 VARCHAR2 (240)
PRICING_ATTRIBUTE2 VARCHAR2 (240)
PRICING_ATTRIBUTE3 VARCHAR2 (240)
PRICING_ATTRIBUTE4 VARCHAR2 (240)
PRICING_ATTRIBUTE5 VARCHAR2 (240)
PRICING_ATTRIBUTE6 VARCHAR2 (240)
PRICING_ATTRIBUTE7 VARCHAR2 (240)
PRICING_ATTRIBUTE8 VARCHAR2 (240)
PRICING_ATTRIBUTE9 VARCHAR2 (240)
PRICING_ATTRIBUTE10 VARCHAR2 (240)
INDUSTRY_CONTEXT VARCHAR2 (30)
INDUSTRY_ATTRIBUTE1 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE2 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE3 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE4 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE5 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE6 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE7 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE8 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE9 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE10 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE11 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE13 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE12 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE14 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE15 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE16 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE17 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE18 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE19 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE20 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE21 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE22 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE23 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE24 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE25 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE26 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE27 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE28 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE29 VARCHAR2 (240)
INDUSTRY_ATTRIBUTE30 VARCHAR2 (240)
CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

CONFIGURATION_ID NUMBER

COMPONENT_SEQUENCE_ID NUMBER

COMPONENT_CODE VARCHAR2 (1000)
CONFIG_DISPLAY_SEQUENCE NUMBER

SORT_ORDER VARCHAR2 (240)
ITEM_TYPE_CODE VARCHAR2 (30)
OPTION_NUMBER NUMBER

OPTION_FLAG VARCHAR2 (1)
DEP_PLAN_REQUIRED_FLAG VARCHAR2 (1)
VISIBLE_DEMAND_FLAG VARCHAR2 (1)
LINE_CATEGORY_CODE VARCHAR2 (30)
ACTUAL_SHIPMENT_DATE DATE

CUSTOMER_TRX_LINE_ID NUMBER

RETURN_CONTEXT VARCHAR2 (30)
RETURN_ATTRIBUTE1 VARCHAR2 (240)
RETURN_ATTRIBUTE2 VARCHAR2 (240)
RETURN_ATTRIBUTE3 VARCHAR2 (240)
RETURN_ATTRIBUTE4 VARCHAR2 (240)
RETURN_ATTRIBUTE5 VARCHAR2 (240)
RETURN_ATTRIBUTE6 VARCHAR2 (240)
RETURN_ATTRIBUTE7 VARCHAR2 (240)
RETURN_ATTRIBUTE8 VARCHAR2 (240)
RETURN_ATTRIBUTE9 VARCHAR2 (240)
RETURN_ATTRIBUTE10 VARCHAR2 (240)
RETURN_ATTRIBUTE11 VARCHAR2 (240)
RETURN_ATTRIBUTE12 VARCHAR2 (240)
RETURN_ATTRIBUTE13 VARCHAR2 (240)
RETURN_ATTRIBUTE14 VARCHAR2 (240)
RETURN_ATTRIBUTE15 VARCHAR2 (240)
INTMED_SHIP_TO_ORG_ID NUMBER

INTMED_SHIP_TO_CONTACT_ID NUMBER

ACTUAL_ARRIVAL_DATE DATE

ATO_LINE_ID NUMBER

AUTO_SELECTED_QUANTITY NUMBER

COMPONENT_NUMBER NUMBER

EARLIEST_ACCEPTABLE_DATE DATE

EXPLOSION_DATE DATE

LATEST_ACCEPTABLE_DATE DATE

MODEL_GROUP_NUMBER NUMBER

SCHEDULE_ARRIVAL_DATE DATE

SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
SCHEDULE_STATUS_CODE VARCHAR2 (30)
SOURCE_TYPE_CODE VARCHAR2 (30)
TOP_MODEL_LINE_ID NUMBER

BOOKED_FLAG VARCHAR2 (1)
CANCELLED_FLAG VARCHAR2 (1)
OPEN_FLAG VARCHAR2 (1)
LOAD_SEQ_NUMBER NUMBER

DELIVERY_ID NUMBER

SALESREP_ID NUMBER (15)
RETURN_REASON_CODE VARCHAR2 (30)
WF_ACTIVITY_CODE VARCHAR2 (50)
WF_RESULT_CODE VARCHAR2 (50)
REASON_CODE VARCHAR2 (30)
HIST_COMMENTS VARCHAR2 (2000)
HIST_TYPE_CODE VARCHAR2 (30) Yes
HIST_CREATION_DATE DATE

HIST_CREATED_BY NUMBER

CUST_PRODUCTION_SEQ_NUM VARCHAR2 (50)
AUTHORIZED_TO_SHIP_FLAG VARCHAR2 (1)
SPLIT_FROM_LINE_ID NUMBER

OVER_SHIP_REASON_CODE VARCHAR2 (30)
OVER_SHIP_RESOLVED_FLAG VARCHAR2 (1)
ITEM_IDENTIFIER_TYPE VARCHAR2 (25)
ARRIVAL_SET_ID NUMBER

SHIP_SET_ID NUMBER

COMMITMENT_ID NUMBER

SHIPPING_INTERFACED_FLAG VARCHAR2 (1)
CREDIT_INVOICE_LINE_ID NUMBER

MFG_COMPONENT_SEQUENCE_ID NUMBER

TP_CONTEXT VARCHAR2 (30)
TP_ATTRIBUTE1 VARCHAR2 (240)
TP_ATTRIBUTE2 VARCHAR2 (240)
TP_ATTRIBUTE3 VARCHAR2 (240)
TP_ATTRIBUTE4 VARCHAR2 (240)
TP_ATTRIBUTE5 VARCHAR2 (240)
TP_ATTRIBUTE6 VARCHAR2 (240)
TP_ATTRIBUTE7 VARCHAR2 (240)
TP_ATTRIBUTE8 VARCHAR2 (240)
TP_ATTRIBUTE9 VARCHAR2 (240)
TP_ATTRIBUTE10 VARCHAR2 (240)
TP_ATTRIBUTE11 VARCHAR2 (240)
TP_ATTRIBUTE12 VARCHAR2 (240)
TP_ATTRIBUTE13 VARCHAR2 (240)
TP_ATTRIBUTE14 VARCHAR2 (240)
TP_ATTRIBUTE15 VARCHAR2 (240)
FULFILLMENT_METHOD_CODE VARCHAR2 (30)
SERVICE_REFERENCE_TYPE_CODE VARCHAR2 (30)
SERVICE_REFERENCE_LINE_ID NUMBER

SERVICE_REFERENCE_SYSTEM_ID NUMBER

INVOICE_INTERFACE_STATUS_CODE VARCHAR2 (30)
ORDERED_ITEM VARCHAR2 (2000)
ORDERED_ITEM_ID NUMBER

SERVICE_NUMBER NUMBER

SERVICED_LINE_ID NUMBER

SERVICE_DURATION NUMBER

SERVICE_START_DATE DATE

RE_SOURCE_FLAG VARCHAR2 (1)
FLOW_STATUS_CODE VARCHAR2 (30)
SERVICE_END_DATE DATE

SERVICE_COTERMINATE_FLAG VARCHAR2 (1)
SHIPPABLE_FLAG VARCHAR2 (1)
ORDER_SOURCE_ID NUMBER

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

CUSTOMER_PAYMENT_TERM_ID NUMBER

FIRST_ACK_DATE DATE

FIRST_ACK_CODE VARCHAR2 (30)
LAST_ACK_CODE VARCHAR2 (30)
LAST_ACK_DATE DATE

PLANNING_PRIORITY NUMBER

SERVICE_TXN_COMMENTS VARCHAR2 (2000)
SERVICE_PERIOD VARCHAR2 (3)
UNIT_SELLING_PERCENT NUMBER

UNIT_LIST_PERCENT NUMBER

UNIT_PERCENT_BASE_PRICE NUMBER

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

CUSTOMER_ITEM_REVISION VARCHAR2 (50)
ITEM_ID NUMBER

INVOICE_COMPLETE_FLAG VARCHAR2 (1)
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
FULFILLED_FLAG VARCHAR2 (1)
CONFIG_HEADER_ID NUMBER

CONFIG_REV_NBR NUMBER

SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
PACKING_INSTRUCTIONS VARCHAR2 (2000)
INVOICED_QUANTITY NUMBER

REFERENCE_CUSTOMER_TRX_LINE_ID NUMBER

SPLIT_BY VARCHAR2 (30)
LINE_SET_ID NUMBER

REVENUE_AMOUNT NUMBER

FULFILLMENT_DATE DATE

PREFERRED_GRADE VARCHAR2 (150)
ORDERED_QUANTITY2 NUMBER

ORDERED_QUANTITY_UOM2 VARCHAR2 (3)
SHIPPED_QUANTITY2 NUMBER

CANCELLED_QUANTITY2 NUMBER

SHIPPING_QUANTITY2 NUMBER

SHIPPING_QUANTITY_UOM2 VARCHAR2 (3)
FULFILLED_QUANTITY2 NUMBER

SUBINVENTORY VARCHAR2 (10)
RESPONSIBILITY_ID NUMBER

UNIT_LIST_PRICE_PER_PQTY NUMBER

UNIT_SELLING_PRICE_PER_PQTY NUMBER

LATEST_CANCELLED_QUANTITY NUMBER

PRICE_REQUEST_CODE VARCHAR2 (240)
LATE_DEMAND_PENALTY_FACTOR NUMBER

OVERRIDE_ATP_DATE_CODE VARCHAR2 (30)
ITEM_SUBSTITUTION_TYPE_CODE VARCHAR2 (30)
ORIGINAL_ITEM_IDENTIFIER_TYPE VARCHAR2 (30)
ORIGINAL_ORDERED_ITEM VARCHAR2 (2000)
ORIGINAL_ORDERED_ITEM_ID NUMBER

ORIGINAL_INVENTORY_ITEM_ID NUMBER

ACCOUNTING_RULE_DURATION NUMBER (15)
USER_ITEM_DESCRIPTION VARCHAR2 (1000)
ITEM_RELATIONSHIP_TYPE NUMBER

BLANKET_LINE_NUMBER NUMBER

BLANKET_VERSION_NUMBER NUMBER

BLANKET_NUMBER NUMBER

VERSION_NUMBER NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

BLANKET_LINE_MAX_AMOUNT NUMBER

BLANKET_LINE_MIN_AMOUNT NUMBER

ENFORCE_PRICE_LIST_FLAG VARCHAR2 (1)
RELEASED_AMOUNT NUMBER

RETURNED_AMOUNT NUMBER

MAX_RELEASE_AMOUNT NUMBER

MIN_RELEASE_AMOUNT NUMBER

BLANKET_MAX_QUANTITY NUMBER

BLANKET_MIN_QUANTITY NUMBER

MAX_RELEASE_QUANTITY NUMBER

MIN_RELEASE_QUANTITY NUMBER

OVERRIDE_RELEASE_CONTROLS_FLAG VARCHAR2 (1)
OVERRIDE_BLANKET_CONTROLS_FLAG VARCHAR2 (1)
RETURNED_QUANTITY NUMBER

RELEASED_QUANTITY NUMBER

QP_LIST_LINE_ID NUMBER

ORDER_NUMBER NUMBER

ENFORCE_ACCOUNTING_RULE_FLAG VARCHAR2 (1) Yes
ENFORCE_INVOICING_RULE_FLAG VARCHAR2 (1) Yes
ENFORCE_SHIP_TO_FLAG VARCHAR2 (1) Yes
ENFORCE_INVOICE_TO_FLAG VARCHAR2 (1) Yes
ENFORCE_FREIGHT_TERM_FLAG VARCHAR2 (1) Yes
ENFORCE_SHIPPING_METHOD_FLAG VARCHAR2 (1) Yes
ENFORCE_PAYMENT_TERM_FLAG VARCHAR2 (1) Yes
SALES_DOCUMENT_TYPE_CODE VARCHAR2 (30)
FULFILLED_AMOUNT NUMBER

TRANSACTION_PHASE_CODE VARCHAR2 (30)
SOURCE_DOCUMENT_VERSION_NUMBER NUMBER

MODIFIER_LIST_LINE_ID NUMBER

AUDIT_FLAG VARCHAR2 (1)
VERSION_FLAG VARCHAR2 (1)
PHASE_CHANGE_FLAG VARCHAR2 (1)
REASON_ID NUMBER

ORDER_FIRMED_DATE DATE

ACTUAL_FULFILLMENT_DATE DATE

INST_ID NUMBER

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# references the following:

SchemaONT
TableOE_BLANKET_LINES_HIST
ONT.OE_BLANKET_LINES_HIST# is referenced by following:

SchemaAPPS
SynonymOE_BLANKET_LINES_HIST