[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.ICX_SO_LINES_VIEW_LINES_V is not referenced by any database object
|
|
|