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: APPS.ICX_SO_LINES_VIEW_LINES_V

Object Details

Object Name:	ICX_SO_LINES_VIEW_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.ICX_SO_LINES_VIEW_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
LINE_ID	NUMBER		Yes	Order entry line identifier
HEADER_ID	NUMBER		Yes	Order entry header identifier
ORDERED_QUANTITY	NUMBER			Ordered quantity
CANCELLED_QUANTITY	NUMBER			Cancelled quantity
OPEN_QUANTITY	NUMBER			Open quantity (difference between ordered quantity and cancelled quantity)
SCHEDULE_STATUS	VARCHAR2	(4000)		Schedule status
UNIT_CODE	VARCHAR2	(3)
SHIPPED_QUANTITY	NUMBER
SCHEDULE_DATE	DATE
DATE_REQUESTED_CURRENT	DATE
PROMISE_DATE	DATE
SHIP_SET_NUMBER	NUMBER
HOLD	VARCHAR2	(4000)		Hold status
DISCOUNT	NUMBER			Discount amount (difference between list price and selling price)
SELLING_PRICE	VARCHAR2	(4000)		Formatted selling price
LIST_PRICE	VARCHAR2	(4000)		Formatted list price
EXTENDED_PRICE	VARCHAR2	(4000)		Extended price (selling price * (ordered quantity - cancelled quantity))
TAX_CODE	VARCHAR2	(50)
LINE_TOTAL	VARCHAR2	(4000)		Line total amount
OPTION_NUMBER	VARCHAR2	(40)		Option number
SHIPMENT_NUMBER	NUMBER			Shipment number
LINE_NUMBER	NUMBER			Line number
RESERVED_QUANTITY	NUMBER			Reserved quantity
ITEM	VARCHAR2	(4000)
ITEM_DESC	VARCHAR2	(240)		Item description
LINE_TYPE_CODE	VARCHAR2	(30)	Yes
SERVICE_PARENT_LINE_ID	NUMBER
PARENT_LINE_ID	NUMBER
ORIGINAL_SYSTEM_LINE_REFERENCE	VARCHAR2	(50)
SHIPMENT_SCHEDULE_LINE_ID	NUMBER
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)
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)
CONTEXT	VARCHAR2	(30)
DUMMY_ID	NUMBER			Dummy identifier 0
ITEM_URL	VARCHAR2	(240)		Item URL
PROJECT_ID	NUMBER			Project identifier
PROJECT_NUMBER	VARCHAR2	(25)		Project number
TASK_ID	NUMBER			Task identifier
TASK_NUMBER	VARCHAR2	(25)		Task number

Query Text

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


SELECT LINE_ID
,      HEADER_ID
,      ORDERED_QUANTITY
,      CANCELLED_QUANTITY
,      OPEN_QUANTITY
,      SCHEDULE_STATUS
,      UNIT_CODE
,      SHIPPED_QUANTITY
,      SCHEDULE_DATE
,      DATE_REQUESTED_CURRENT
,      PROMISE_DATE
,      SHIP_SET_NUMBER
,      HOLD
,      DISCOUNT
,      SELLING_PRICE
,      LIST_PRICE
,      EXTENDED_PRICE
,      TAX_CODE
,      LINE_TOTAL
,      OPTION_NUMBER
,      SHIPMENT_NUMBER
,      LINE_NUMBER
,      RESERVED_QUANTITY
,      ITEM
,      ITEM_DESC
,      LINE_TYPE_CODE
,      SERVICE_PARENT_LINE_ID
,      PARENT_LINE_ID
,      ORIGINAL_SYSTEM_LINE_REFERENCE
,      SHIPMENT_SCHEDULE_LINE_ID
,      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
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      DUMMY_ID
,      ITEM_URL
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
FROM APPS.ICX_SO_LINES_VIEW_LINES_V;

Dependencies

[top of page]

APPS.ICX_SO_LINES_VIEW_LINES_V references the following:

APPS: FND_CURRENCY - show dependent code; FND_PROFILE - show dependent code; MTL_SYSTEM_ITEMS; OEXVWLIN - show dependent code; PA_PROJECTS; PA_TASKS; SO_HEADERS; SO_LINES

APPS.ICX_SO_LINES_VIEW_LINES_V is not referenced by any database object