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

VIEW: APPS.BOM_LINES_VIEW

Object Details
Object Name: BOM_LINES_VIEW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBOM.BOM_LINES_VIEW
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
LINE_ID NUMBER
Yes System-generated identifier of order, configuration or shipment schedule line
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent program that last changed line
PROGRAM_ID NUMBER

Standard Who column x
PROGRAM_UPDATE_DATE DATE

Last date changed by concurrent program
SOURCE_LINE_ID NUMBER

Identifier of shipment schedule parent option line from which shipment schedule line is copied
ORIGINAL_SYSTEM_LINE_REFERENCE VARCHAR2 (50)
Identifier of a line from a source system outside of Oracle Order Entry
HEADER_ID NUMBER
Yes System-generated identifier of order header
SHIPMENT_SCHEDULE_LINE_ID NUMBER

Identifier of shipment schedule parent line
PARENT_LINE_ID NUMBER

Identifier of configuration top parent line
ATO_LINE_ID NUMBER

Identifier of ATO configuration top model line
LINK_TO_LINE_ID NUMBER

Identifier of immediate parent component line
SERVICE_PARENT_LINE_ID NUMBER

(for internal use only)
LINE_TYPE_CODE VARCHAR2 (30) Yes Indicates if line is part of a shipment schedule, top shipment schedule line, regular or return line
OPTION_FLAG VARCHAR2 (1) Yes Indicates if line is an option in a configuration
OPEN_FLAG VARCHAR2 (1)
Indicates if line has completed the order cycle.
CYCLE_ID NUMBER

System-generated identifier of order cycle
LINE_NUMBER NUMBER

Line sequence number
INVENTORY_ITEM_ID NUMBER
Yes System-generated identifier of inventory item
COMPONENT_SEQUENCE_ID NUMBER

Component identifier
ITEM_TYPE_CODE VARCHAR2 (30) Yes Type of item
ATO_FLAG VARCHAR2 (1) Yes Indicates if line is ATO
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
Indicates if line is in a ship-complete configuration
COMPONENT_CODE VARCHAR2 (1000)
Identifier of component within an exploded bill
COMPONENT_SORT_CODE VARCHAR2 (240)
Sorting sequence for a component within a bill
STANDARD_COMPONENT_FREEZE_DATE DATE

Date when included item are frozen
CONFIGURATION_EDITED_FLAG VARCHAR2 (1)
Not used
ORDERED_QUANTITY NUMBER

Quantity ordered
CANCELLED_QUANTITY NUMBER

Quantity cancelled
UNIT_CODE VARCHAR2 (3)
Unit of measure
PRICE_LIST_ID NUMBER

System-generated identifier of price list
PRICING_METHOD_CODE VARCHAR2 (30)
Method used to calculate price
LIST_PRICE NUMBER

Price list price of item
SELLING_PRICE NUMBER

Actual price charged to customer
LIST_PERCENT NUMBER

Price list percent of the item
SELLING_PERCENT NUMBER

Percent actually charged to customer
PERCENT_BASE_PRICE NUMBER

Base price used for percent-based pricing
PRICING_CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column
PRICING_ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
PRICING_ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
WAREHOUSE_ID NUMBER

System-generated identifier of inventory organization
DEMAND_CLASS_CODE VARCHAR2 (30)
Demand class
SCHEDULE_DATE DATE

Date planned to ship item
SHIP_SET_NUMBER NUMBER

Ship set number
SHIPPED_QUANTITY NUMBER

Quantity shipped on line
DATE_REQUESTED_CURRENT DATE

Date requested by customer to receive item
PROMISE_DATE DATE

Date promised to customer to receive item
SHIP_TO_SITE_USE_ID NUMBER

Location to which line is to be shipped
SHIP_TO_CONTACT_ID NUMBER

Person to which line is to be shipped
SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
Shipment priority
SHIP_METHOD_CODE VARCHAR2 (30)
Freight carrier
AGREEMENT_ID NUMBER

(For internal use)
COMMITMENT_ID NUMBER

Commitment to apply line against
TERMS_ID NUMBER

System-generated identifier of payment terms
INVOICING_RULE_ID NUMBER

Invoicing rule
ACCOUNTING_RULE_ID NUMBER

Accouting rule
INVOICE_COUNT NUMBER

Number of times line has been incrementally billed
INVOICED_QUANTITY NUMBER

Quantity invoiced
QUANTITY_TO_INVOICE NUMBER

Current quantity outstanding to be invoiced
REVENUE_AMOUNT NUMBER

Unit price to invoice
TAX_EXEMPT_NUMBER VARCHAR2 (80)
Tax exemption certificate number
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
Tax exemption reason
TRANSACTION_TYPE_CODE VARCHAR2 (30)
For internal use only
TRANSACTION_REASON_CODE VARCHAR2 (30)
Reason for return of item
TRANSACTION_COMMENTS VARCHAR2 (240)
For internal use only
RETURN_REFERENCE_TYPE_CODE VARCHAR2 (30)
Type of line to which return line is related
RETURN_REFERENCE_ID NUMBER

Order line or invoice line to which return line is related
CREDIT_INVOICE_LINE_ID NUMBER

Credit invoice line of return
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Inspection required indicator for RMA
CUSTOMER_PRODUCT_ID NUMBER

For internal use only
CP_SERVICE_ID NUMBER

For internal use only
SERVICED_QUANTITY NUMBER

For internal use only
SERVICE_DURATION NUMBER

For internal use only
SERVICE_START_DATE DATE

For internal use only
SERVICE_END_DATE DATE

For internal use only
SERVICE_COTERMINATE_FLAG VARCHAR2 (1)
For internal use only
SERVICE_PERIOD_CONVERSION_RATE NUMBER

For internal use only
SERVICE_MASS_TXN_TEMP_ID NUMBER

For internal use only
NUMBER_SVRID NUMBER

Standard value rule from which line number is derived
ITEM_SVRID NUMBER

Standard value rule from which attribute is derived
ORDERED_QUANTITY_SVRID NUMBER

Standard value rule from which attribute is derived
UNIT_SVRID NUMBER

Standard value rule from which attribute is derived
PRICING_ATTRIBUTES_SVRID NUMBER

Standard value rule from which attribute is derived
LIST_PRICE_SVRID NUMBER

Standard value rule from which attribute is derived
SELLING_PRICE_SVRID NUMBER

Standard value rule from which attribute is derived
LIST_PERCENT_SVRID NUMBER

Standard value rule from which attribute is derived
SELLING_PERCENT_SVRID NUMBER

Standard value rule from which attribute is derived
WAREHOUSE_SVRID NUMBER

Standard value rule from which attribute is derived
DEMAND_CLASS_SVRID NUMBER

Standard value rule from which attribute is derived
SHIP_SET_NUMBER_SVRID NUMBER

Standard value rule from which attribute is derived
REQUEST_DATE_SVRID NUMBER

Standard value rule from which attribute is derived
PROMISE_DATE_SVRID NUMBER

Standard value rule from which attribute is derived
SCHEDULE_DATE_SVRID NUMBER

Standard value rule from which attribute is derived
SHIP_TO_SVRID NUMBER

Standard value rule from which attribute is derived
SHIP_TO_CONTACT_SVRID NUMBER

Standard value rule from which attribute is derived
SHIPMENT_PRIORITY_SVRID NUMBER

Standard value rule from which attribute is derived
FREIGHT_CARRIER_SVRID NUMBER

Standard value rule from which attribute is derived
AGREEMENT_SVRID NUMBER

Standard value rule from which attribute is derived
COMMITMENT_SVRID NUMBER

Standard value rule from which attribute is derived
PAYMENT_TERMS_SVRID NUMBER

Standard value rule from which attribute is derived
INVOICING_RULE_SVRID NUMBER

Standard value rule from which attribute is derived
ACCOUNTING_RULE_SVRID NUMBER

Standard value rule from which attribute is derived
TAX_EXEMPT_NUMBER_SVRID NUMBER

Standard value rule from which attribute is derived
TAX_EXEMPT_REASON_SVRID NUMBER

Standard value rule from which attribute is derived
TRANSACTION_TYPE_SVRID NUMBER

Standard value rule from which attribute is derived
TRANSACTION_REASON_SVRID NUMBER

Standard value rule from which attribute is derived
TRANSACTION_COMMENTS_SVRID NUMBER

Standard value rule from which attribute is derived
RETURN_REFERENCE_TYPE_SVRID NUMBER

Standard value rule from which attribute is derived
RETURN_REFERENCE_SVRID NUMBER

Standard value rule from which attribute is derived
CREDIT_INVOICE_LINE_SVRID NUMBER

Standard value rule from which attribute is derived
INSPECTION_REQUIRED_SVRID NUMBER

Standard value rule from which attribute is derived
CUSTOMER_PRODUCT_SVRID NUMBER

Standard value rule from which attribute is derived
CUSTOMER_PRODUCT_SERVICE_SVRID NUMBER

Standard value rule from which attribute is derived
SERVICE_DURATION_SVRID NUMBER

Standard value rule from which attribute is derived
SERVICE_START_DATE_SVRID NUMBER

Standard value rule from which attribute is derived
SERVICE_END_DATE_SVRID NUMBER

Standard value rule from which attribute is derived
SERVICE_PER_CONV_RATE_SVRID NUMBER

Standard value rule from which attribute is derived
SERVICE_COTERMINATE_SVRID NUMBER

Standard value rule from which attribute is derived
DF_SVRID NUMBER

Standard value rule from which attribute is derived
S1 NUMBER

Cycle action status column
S1_DATE DATE

Cycle action status date column
S2 NUMBER

Cycle action status column
S2_DATE DATE

Cycle action status date column
S3 NUMBER

Cycle action status column
S3_DATE DATE

Cycle action status date column
S4 NUMBER

Cycle action status column
S4_DATE DATE

Cycle action status date column
S5 NUMBER

Cycle action status column
S5_DATE DATE

Cycle action status date column
S6 NUMBER

Cycle action status column
S6_DATE DATE

Cycle action status date column
S7 NUMBER

Cycle action status column
S7_DATE DATE

Cycle action status date column
S8 NUMBER

Cycle action status column
S8_DATE DATE

Cycle action status date column
S9 NUMBER

Cycle action status column
S9_DATE DATE

Cycle action status date column
S10 NUMBER

Cycle action status column
S10_DATE DATE

Cycle action status date column
S11 NUMBER

Cycle action status column
S11_DATE DATE

Cycle action status date column
S12 NUMBER

Cycle action status column
S12_DATE DATE

Cycle action status date column
S13 NUMBER

Cycle action status column
S13_DATE DATE

Cycle action status date column
S14 NUMBER

Cycle action status column
S14_DATE DATE

Cycle action status date column
S15 NUMBER

Cycle action status column
S15_DATE DATE

Cycle action status date column
S16 NUMBER

Cycle action status column
S16_DATE DATE

Cycle action status date column
S17 NUMBER

Cycle action status column
S17_DATE DATE

Cycle action status date column
S18 NUMBER

Cycle action status column
S18_DATE DATE

Cycle action status date column
S19 NUMBER

Cycle action status column
S19_DATE DATE

Cycle action status date column
S20 NUMBER

Cycle action status column
S20_DATE DATE

Cycle action status date column
S21 NUMBER

Cycle action status column
S21_DATE DATE

Cycle action status date column
S22 NUMBER

Cycle action status column
S22_DATE DATE

Cycle action status date column
S23 NUMBER

Cycle action status column
S23_DATE DATE

Cycle action status date column
S24 NUMBER

Cycle action status column
S24_DATE DATE

Cycle action status date column
S25 NUMBER

Cycle action status column
S25_DATE DATE

Cycle action status date column
S26 NUMBER

Cycle action status column
S26_DATE DATE

Cycle action status date column
S27 NUMBER

Cycle action status column
S27_DATE DATE

Cycle action status date column
S28 NUMBER

Cycle action status column
S28_DATE DATE

Cycle action status date column
S29 NUMBER

Cycle action status column
S29_DATE DATE

Cycle action status date column
S30 NUMBER

Cycle action status column
S30_DATE DATE

Cycle action status date column
CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
PRICING_DATE DATE

Date on which list price or percent is based
LATEST_ACCEPTABLE_DATE DATE

LATEST_ACCEPTABLE_DATE_SVRID NUMBER

Query Text

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


SELECT LINE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SOURCE_LINE_ID
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      HEADER_ID
,      SHIPMENT_SCHEDULE_LINE_ID
,      PARENT_LINE_ID
,      ATO_LINE_ID
,      LINK_TO_LINE_ID
,      SERVICE_PARENT_LINE_ID
,      LINE_TYPE_CODE
,      OPTION_FLAG
,      OPEN_FLAG
,      CYCLE_ID
,      LINE_NUMBER
,      INVENTORY_ITEM_ID
,      COMPONENT_SEQUENCE_ID
,      ITEM_TYPE_CODE
,      ATO_FLAG
,      SHIP_MODEL_COMPLETE_FLAG
,      COMPONENT_CODE
,      COMPONENT_SORT_CODE
,      STANDARD_COMPONENT_FREEZE_DATE
,      CONFIGURATION_EDITED_FLAG
,      ORDERED_QUANTITY
,      CANCELLED_QUANTITY
,      UNIT_CODE
,      PRICE_LIST_ID
,      PRICING_METHOD_CODE
,      LIST_PRICE
,      SELLING_PRICE
,      LIST_PERCENT
,      SELLING_PERCENT
,      PERCENT_BASE_PRICE
,      PRICING_CONTEXT
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      WAREHOUSE_ID
,      DEMAND_CLASS_CODE
,      SCHEDULE_DATE
,      SHIP_SET_NUMBER
,      SHIPPED_QUANTITY
,      DATE_REQUESTED_CURRENT
,      PROMISE_DATE
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      SHIPMENT_PRIORITY_CODE
,      SHIP_METHOD_CODE
,      AGREEMENT_ID
,      COMMITMENT_ID
,      TERMS_ID
,      INVOICING_RULE_ID
,      ACCOUNTING_RULE_ID
,      INVOICE_COUNT
,      INVOICED_QUANTITY
,      QUANTITY_TO_INVOICE
,      REVENUE_AMOUNT
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      TRANSACTION_TYPE_CODE
,      TRANSACTION_REASON_CODE
,      TRANSACTION_COMMENTS
,      RETURN_REFERENCE_TYPE_CODE
,      RETURN_REFERENCE_ID
,      CREDIT_INVOICE_LINE_ID
,      INSPECTION_REQUIRED_FLAG
,      CUSTOMER_PRODUCT_ID
,      CP_SERVICE_ID
,      SERVICED_QUANTITY
,      SERVICE_DURATION
,      SERVICE_START_DATE
,      SERVICE_END_DATE
,      SERVICE_COTERMINATE_FLAG
,      SERVICE_PERIOD_CONVERSION_RATE
,      SERVICE_MASS_TXN_TEMP_ID
,      NUMBER_SVRID
,      ITEM_SVRID
,      ORDERED_QUANTITY_SVRID
,      UNIT_SVRID
,      PRICING_ATTRIBUTES_SVRID
,      LIST_PRICE_SVRID
,      SELLING_PRICE_SVRID
,      LIST_PERCENT_SVRID
,      SELLING_PERCENT_SVRID
,      WAREHOUSE_SVRID
,      DEMAND_CLASS_SVRID
,      SHIP_SET_NUMBER_SVRID
,      REQUEST_DATE_SVRID
,      PROMISE_DATE_SVRID
,      SCHEDULE_DATE_SVRID
,      SHIP_TO_SVRID
,      SHIP_TO_CONTACT_SVRID
,      SHIPMENT_PRIORITY_SVRID
,      FREIGHT_CARRIER_SVRID
,      AGREEMENT_SVRID
,      COMMITMENT_SVRID
,      PAYMENT_TERMS_SVRID
,      INVOICING_RULE_SVRID
,      ACCOUNTING_RULE_SVRID
,      TAX_EXEMPT_NUMBER_SVRID
,      TAX_EXEMPT_REASON_SVRID
,      TRANSACTION_TYPE_SVRID
,      TRANSACTION_REASON_SVRID
,      TRANSACTION_COMMENTS_SVRID
,      RETURN_REFERENCE_TYPE_SVRID
,      RETURN_REFERENCE_SVRID
,      CREDIT_INVOICE_LINE_SVRID
,      INSPECTION_REQUIRED_SVRID
,      CUSTOMER_PRODUCT_SVRID
,      CUSTOMER_PRODUCT_SERVICE_SVRID
,      SERVICE_DURATION_SVRID
,      SERVICE_START_DATE_SVRID
,      SERVICE_END_DATE_SVRID
,      SERVICE_PER_CONV_RATE_SVRID
,      SERVICE_COTERMINATE_SVRID
,      DF_SVRID
,      S1
,      S1_DATE
,      S2
,      S2_DATE
,      S3
,      S3_DATE
,      S4
,      S4_DATE
,      S5
,      S5_DATE
,      S6
,      S6_DATE
,      S7
,      S7_DATE
,      S8
,      S8_DATE
,      S9
,      S9_DATE
,      S10
,      S10_DATE
,      S11
,      S11_DATE
,      S12
,      S12_DATE
,      S13
,      S13_DATE
,      S14
,      S14_DATE
,      S15
,      S15_DATE
,      S16
,      S16_DATE
,      S17
,      S17_DATE
,      S18
,      S18_DATE
,      S19
,      S19_DATE
,      S20
,      S20_DATE
,      S21
,      S21_DATE
,      S22
,      S22_DATE
,      S23
,      S23_DATE
,      S24
,      S24_DATE
,      S25
,      S25_DATE
,      S26
,      S26_DATE
,      S27
,      S27_DATE
,      S28
,      S28_DATE
,      S29
,      S29_DATE
,      S30
,      S30_DATE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PRICING_DATE
,      LATEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE_SVRID
FROM APPS.BOM_LINES_VIEW;

Dependencies

[top of page]

APPS.BOM_LINES_VIEW references the following:

SchemaAPPS
SynonymSO_LINES_ALL

APPS.BOM_LINES_VIEW is not referenced by any database object