eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: OE.SO_LINES_INTERFACE_ALL#

Object Details

Object Name:	SO_LINES_INTERFACE_ALL#
Object Type:	VIEW
Owner:	OE
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
PROGRAM_APPLICATION_ID	NUMBER	(15)
PROGRAM_ID	NUMBER	(15)
PROGRAM_UPDATE_DATE	DATE
REQUEST_ID	NUMBER
ORIGINAL_SYSTEM_REFERENCE	VARCHAR2	(50)	Yes
ORIGINAL_SYSTEM_LINE_REFERENCE	VARCHAR2	(50)	Yes
LINE_NUMBER	NUMBER		Yes
LINE_TYPE	VARCHAR2	(30)	Yes
UNIT_CODE	VARCHAR2	(3)	Yes
ORDERED_QUANTITY	NUMBER		Yes
DATE_REQUESTED_CURRENT	DATE
LIST_PRICE	NUMBER
SELLING_PRICE	NUMBER
LIST_PERCENT	NUMBER
SELLING_PERCENT	NUMBER
INVENTORY_ITEM_SEGMENT1	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT2	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT3	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT4	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT5	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT6	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT7	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT8	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT9	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT10	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT11	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT12	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT13	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT14	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT15	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT16	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT17	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT18	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT19	VARCHAR2	(40)
INVENTORY_ITEM_SEGMENT20	VARCHAR2	(40)
INVENTORY_ITEM_ID	NUMBER
SHIPPED_QUANTITY	NUMBER
SCHEDULED_SHIPMENT_DATE	DATE
LINK_TO_LINE_REF	VARCHAR2	(50)
PARENT_LINE_REF	VARCHAR2	(50)
SHIPMENT_SCHEDULE_LINE_REF	VARCHAR2	(50)
SHIP_SET_NUMBER	NUMBER
SHIP_TO_SITE_USE_ID	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
SHIP_METHOD_CODE	VARCHAR2	(30)
PRICE_LIST_ID	NUMBER
TERMS_ID	NUMBER
WAREHOUSE_ID	NUMBER
SERVICED_SEGMENT1	VARCHAR2	(40)
SERVICED_SEGMENT2	VARCHAR2	(40)
SERVICED_SEGMENT3	VARCHAR2	(40)
SERVICED_SEGMENT4	VARCHAR2	(40)
SERVICED_SEGMENT5	VARCHAR2	(40)
SERVICED_SEGMENT6	VARCHAR2	(40)
SERVICED_SEGMENT7	VARCHAR2	(40)
SERVICED_SEGMENT8	VARCHAR2	(40)
SERVICED_SEGMENT9	VARCHAR2	(40)
SERVICED_SEGMENT10	VARCHAR2	(40)
SERVICED_SEGMENT11	VARCHAR2	(40)
SERVICED_SEGMENT12	VARCHAR2	(40)
SERVICED_SEGMENT13	VARCHAR2	(40)
SERVICED_SEGMENT14	VARCHAR2	(40)
SERVICED_SEGMENT15	VARCHAR2	(40)
SERVICED_SEGMENT16	VARCHAR2	(40)
SERVICED_SEGMENT17	VARCHAR2	(40)
SERVICED_SEGMENT18	VARCHAR2	(40)
SERVICED_SEGMENT19	VARCHAR2	(40)
SERVICED_SEGMENT20	VARCHAR2	(40)
SERVICED_ITEM_ID	NUMBER
SERVICED_LIST_PRICE	NUMBER
SERVICE_START_DATE_ACTIVE	DATE
SERVICE_END_DATE_ACTIVE	DATE
CUSTOMER_PRODUCT_ID	NUMBER
CP_SERVICE_ID	NUMBER
TRANSACTION_TYPE_CODE	VARCHAR2	(30)
SERVICE_DURATION_QUANTITY	NUMBER
TRANSACTION_REASON_CODE	VARCHAR2	(30)
TRANSACTION_COMMENTS	VARCHAR2	(240)
SERVICE_MASS_TXN_TEMP_ID	NUMBER
AGREEMENT_NAME	VARCHAR2	(30)
AGREEMENT_ID	NUMBER
ACCOUNTING_RULE	VARCHAR2	(30)
ACCOUNTING_RULE_ID	NUMBER
INVOICING_RULE_ID	NUMBER
SERVICED_UNIT_CODE	VARCHAR2	(3)
SERVICED_PRICING_ATTRIBUTE1	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE2	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE3	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE4	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE5	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE6	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE7	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE8	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE9	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE10	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE11	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE12	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE13	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE14	VARCHAR2	(150)
SERVICED_PRICING_ATTRIBUTE15	VARCHAR2	(150)
SERVICED_PRICING_CONTEXT	VARCHAR2	(30)
ORDER_CATEGORY	VARCHAR2	(30)
ENTERED_STATE	VARCHAR2	(30)
ENTERED_STATE_DATE	DATE
COMPLETE_FLAG	VARCHAR2	(1)
SCHEDULE_STATUS_CODE	VARCHAR2	(30)
CONTEXT	VARCHAR2	(30)
ATTRIBUTE1	VARCHAR2	(150)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
ATTRIBUTE15	VARCHAR2	(150)
CALCULATE_PRICE	VARCHAR2	(1)
PRICING_ATTRIBUTE1	VARCHAR2	(150)
PRICING_ATTRIBUTE2	VARCHAR2	(150)
PRICING_ATTRIBUTE3	VARCHAR2	(150)
PRICING_ATTRIBUTE4	VARCHAR2	(150)
PRICING_ATTRIBUTE5	VARCHAR2	(150)
PRICING_ATTRIBUTE6	VARCHAR2	(150)
PRICING_ATTRIBUTE7	VARCHAR2	(150)
PRICING_ATTRIBUTE8	VARCHAR2	(150)
PRICING_ATTRIBUTE9	VARCHAR2	(150)
PRICING_ATTRIBUTE10	VARCHAR2	(150)
PRICING_ATTRIBUTE11	VARCHAR2	(150)
PRICING_ATTRIBUTE12	VARCHAR2	(150)
PRICING_ATTRIBUTE13	VARCHAR2	(150)
PRICING_ATTRIBUTE14	VARCHAR2	(150)
PRICING_ATTRIBUTE15	VARCHAR2	(150)
PRICING_CONTEXT	VARCHAR2	(30)
PRICING_METHOD_CODE	VARCHAR2	(30)
COMPONENT_CODE	VARCHAR2	(1000)
COMPONENT_SEQUENCE_ID	NUMBER
COMPONENT_SORT_CODE	VARCHAR2	(240)
ERROR_FLAG	VARCHAR2	(1)
INTERFACE_STATUS	VARCHAR2	(1000)
ITEM_TYPE_CODE	VARCHAR2	(30)
LEVEL_CODE	NUMBER
OPTION_FLAG	VARCHAR2	(1)
ORDER_SOURCE_ID	NUMBER		Yes
SHIP_ADDRESS1	VARCHAR2	(240)
SHIP_ADDRESS2	VARCHAR2	(240)
SHIP_ADDRESS3	VARCHAR2	(240)
SHIP_ADDRESS4	VARCHAR2	(240)
SHIP_ADDRESS_ID	NUMBER
SHIP_CITY	VARCHAR2	(50)
SHIP_COUNTRY	VARCHAR2	(50)
SHIP_COUNTY	VARCHAR2	(50)
SHIP_POSTAL_CODE	VARCHAR2	(30)
SHIP_STATE	VARCHAR2	(50)
SHIP_TO_CONTACT_FIRST_NAME	VARCHAR2	(30)
SHIP_TO_CONTACT_LAST_NAME	VARCHAR2	(50)
TERMS_NAME	VARCHAR2	(15)
GROUP_ID	NUMBER
PERCENT_BASE_PRICE	NUMBER
OPERATION_CODE	VARCHAR2	(30)
COMMITMENT_ID	NUMBER
INVOICING_RULE	VARCHAR2	(30)
SHIP_TO_CUSTOMER	VARCHAR2	(50)
SHIP_TO_CUSTOMER_ID	NUMBER
PRICING_DATE	DATE
LATEST_ACCEPTABLE_DATE	DATE
SERVICE_PARENT_LINE_REF	VARCHAR2	(50)
SERVICE_COTERMINATE_FLAG	VARCHAR2	(1)
SERVICE_PERIOD_CONVERSION_RATE	NUMBER
TAX_CODE	VARCHAR2	(50)
DEMAND_CLASS_CODE	VARCHAR2	(30)
PROMISE_DATE	DATE
ORG_ID	NUMBER
PROJECT_ID	NUMBER
TASK_ID	NUMBER
DEMAND_STREAM_ID	NUMBER
INTERMEDIATE_SHIP_TO_ID	NUMBER
CUSTOMER_DOCK_CODE	VARCHAR2	(50)
PLANNING_PROD_SEQ_NUMBER	VARCHAR2	(50)
CUSTOMER_ITEM_ID	NUMBER
CUSTOMER_JOB	VARCHAR2	(50)
CUSTOMER_PRODUCTION_LINE	VARCHAR2	(50)
CUSTOMER_MODEL_SERIAL_NUMBER	VARCHAR2	(50)
SOURCE_TYPE_CODE	VARCHAR2	(30)
SOURCE_TYPE_NAME	VARCHAR2	(80)
PLANNING_PRIORITY	NUMBER
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ORIGINAL_SYSTEM_REFERENCE
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      LINE_NUMBER
,      LINE_TYPE
,      UNIT_CODE
,      ORDERED_QUANTITY
,      DATE_REQUESTED_CURRENT
,      LIST_PRICE
,      SELLING_PRICE
,      LIST_PERCENT
,      SELLING_PERCENT
,      INVENTORY_ITEM_SEGMENT1
,      INVENTORY_ITEM_SEGMENT2
,      INVENTORY_ITEM_SEGMENT3
,      INVENTORY_ITEM_SEGMENT4
,      INVENTORY_ITEM_SEGMENT5
,      INVENTORY_ITEM_SEGMENT6
,      INVENTORY_ITEM_SEGMENT7
,      INVENTORY_ITEM_SEGMENT8
,      INVENTORY_ITEM_SEGMENT9
,      INVENTORY_ITEM_SEGMENT10
,      INVENTORY_ITEM_SEGMENT11
,      INVENTORY_ITEM_SEGMENT12
,      INVENTORY_ITEM_SEGMENT13
,      INVENTORY_ITEM_SEGMENT14
,      INVENTORY_ITEM_SEGMENT15
,      INVENTORY_ITEM_SEGMENT16
,      INVENTORY_ITEM_SEGMENT17
,      INVENTORY_ITEM_SEGMENT18
,      INVENTORY_ITEM_SEGMENT19
,      INVENTORY_ITEM_SEGMENT20
,      INVENTORY_ITEM_ID
,      SHIPPED_QUANTITY
,      SCHEDULED_SHIPMENT_DATE
,      LINK_TO_LINE_REF
,      PARENT_LINE_REF
,      SHIPMENT_SCHEDULE_LINE_REF
,      SHIP_SET_NUMBER
,      SHIP_TO_SITE_USE_ID
,      SHIP_TO_CONTACT_ID
,      SHIPMENT_PRIORITY_CODE
,      SHIP_METHOD_CODE
,      PRICE_LIST_ID
,      TERMS_ID
,      WAREHOUSE_ID
,      SERVICED_SEGMENT1
,      SERVICED_SEGMENT2
,      SERVICED_SEGMENT3
,      SERVICED_SEGMENT4
,      SERVICED_SEGMENT5
,      SERVICED_SEGMENT6
,      SERVICED_SEGMENT7
,      SERVICED_SEGMENT8
,      SERVICED_SEGMENT9
,      SERVICED_SEGMENT10
,      SERVICED_SEGMENT11
,      SERVICED_SEGMENT12
,      SERVICED_SEGMENT13
,      SERVICED_SEGMENT14
,      SERVICED_SEGMENT15
,      SERVICED_SEGMENT16
,      SERVICED_SEGMENT17
,      SERVICED_SEGMENT18
,      SERVICED_SEGMENT19
,      SERVICED_SEGMENT20
,      SERVICED_ITEM_ID
,      SERVICED_LIST_PRICE
,      SERVICE_START_DATE_ACTIVE
,      SERVICE_END_DATE_ACTIVE
,      CUSTOMER_PRODUCT_ID
,      CP_SERVICE_ID
,      TRANSACTION_TYPE_CODE
,      SERVICE_DURATION_QUANTITY
,      TRANSACTION_REASON_CODE
,      TRANSACTION_COMMENTS
,      SERVICE_MASS_TXN_TEMP_ID
,      AGREEMENT_NAME
,      AGREEMENT_ID
,      ACCOUNTING_RULE
,      ACCOUNTING_RULE_ID
,      INVOICING_RULE_ID
,      SERVICED_UNIT_CODE
,      SERVICED_PRICING_ATTRIBUTE1
,      SERVICED_PRICING_ATTRIBUTE2
,      SERVICED_PRICING_ATTRIBUTE3
,      SERVICED_PRICING_ATTRIBUTE4
,      SERVICED_PRICING_ATTRIBUTE5
,      SERVICED_PRICING_ATTRIBUTE6
,      SERVICED_PRICING_ATTRIBUTE7
,      SERVICED_PRICING_ATTRIBUTE8
,      SERVICED_PRICING_ATTRIBUTE9
,      SERVICED_PRICING_ATTRIBUTE10
,      SERVICED_PRICING_ATTRIBUTE11
,      SERVICED_PRICING_ATTRIBUTE12
,      SERVICED_PRICING_ATTRIBUTE13
,      SERVICED_PRICING_ATTRIBUTE14
,      SERVICED_PRICING_ATTRIBUTE15
,      SERVICED_PRICING_CONTEXT
,      ORDER_CATEGORY
,      ENTERED_STATE
,      ENTERED_STATE_DATE
,      COMPLETE_FLAG
,      SCHEDULE_STATUS_CODE
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CALCULATE_PRICE
,      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
,      PRICING_CONTEXT
,      PRICING_METHOD_CODE
,      COMPONENT_CODE
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_SORT_CODE
,      ERROR_FLAG
,      INTERFACE_STATUS
,      ITEM_TYPE_CODE
,      LEVEL_CODE
,      OPTION_FLAG
,      ORDER_SOURCE_ID
,      SHIP_ADDRESS1
,      SHIP_ADDRESS2
,      SHIP_ADDRESS3
,      SHIP_ADDRESS4
,      SHIP_ADDRESS_ID
,      SHIP_CITY
,      SHIP_COUNTRY
,      SHIP_COUNTY
,      SHIP_POSTAL_CODE
,      SHIP_STATE
,      SHIP_TO_CONTACT_FIRST_NAME
,      SHIP_TO_CONTACT_LAST_NAME
,      TERMS_NAME
,      GROUP_ID
,      PERCENT_BASE_PRICE
,      OPERATION_CODE
,      COMMITMENT_ID
,      INVOICING_RULE
,      SHIP_TO_CUSTOMER
,      SHIP_TO_CUSTOMER_ID
,      PRICING_DATE
,      LATEST_ACCEPTABLE_DATE
,      SERVICE_PARENT_LINE_REF
,      SERVICE_COTERMINATE_FLAG
,      SERVICE_PERIOD_CONVERSION_RATE
,      TAX_CODE
,      DEMAND_CLASS_CODE
,      PROMISE_DATE
,      ORG_ID
,      PROJECT_ID
,      TASK_ID
,      DEMAND_STREAM_ID
,      INTERMEDIATE_SHIP_TO_ID
,      CUSTOMER_DOCK_CODE
,      PLANNING_PROD_SEQ_NUMBER
,      CUSTOMER_ITEM_ID
,      CUSTOMER_JOB
,      CUSTOMER_PRODUCTION_LINE
,      CUSTOMER_MODEL_SERIAL_NUMBER
,      SOURCE_TYPE_CODE
,      SOURCE_TYPE_NAME
,      PLANNING_PRIORITY
,      END_ITEM_UNIT_NUMBER
FROM OE.SO_LINES_INTERFACE_ALL#;

Dependencies

[top of page]

OE.SO_LINES_INTERFACE_ALL# references the following:

OE: SO_LINES_INTERFACE_ALL

OE.SO_LINES_INTERFACE_ALL# is referenced by following:

APPS: SO_LINES_INTERFACE_ALL