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

VIEW: APPS.ECE_POCO_LINES_V

Object Details
Object Name: ECE_POCO_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewEC.ECE_POCO_LINES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


This view extracts line information
for the outbound Purchase Order Change (860/ORDCHG) transaction.

[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_NUM NUMBER

Line Number
QUANTITY NUMBER

Order Quantity
UOM_CODE VARCHAR2 (25)
Unit of Measure
ITEM_ID NUMBER

Part Number
ITEM_REVISION VARCHAR2 (3)
Item Revison Number
VENDOR_PRODUCT_NUMBER VARCHAR2 (25)
Supplier Product Number
UNIT_PRICE NUMBER

Unit Price
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
PO_NUMBER VARCHAR2 (20)
Contract Purchase Order Number
VENDOR_QUOTE_NUMBER VARCHAR2 (25)
Supplier Quote Number
CANCEL_FLAG VARCHAR2 (1)
Line Cancelled Flag
CANCEL_DATE DATE

Line Cancelled Date
QUANTITY_COMMITTED NUMBER

Blanket Quantity Committed
COMMITTED_AMOUNT NUMBER

Blanket Amount Committed
LIST_PRICE_PER_UNIT NUMBER

List Price
MARKET_PRICE NUMBER

Market Price
NOT_TO_EXCEED_PRICE NUMBER

Unit Price Not to Exceed
NEGOTIATED_BY_PREPARER_FLAG VARCHAR2 (1)
Negotiated Price Flag
TAXABLE_FLAG VARCHAR2 (1)
Taxable Flag
TRANSACTION_REASON_CODE VARCHAR2 (25)
Transaction Reason Code
TYPE_1099 VARCHAR2 (10)
Type 1099
ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25)
Line Order Type
HAZARD_CLASS VARCHAR2 (40)
Hazard Class
UN_NUMBER VARCHAR2 (25)
UN Hazard Class Number
UN_DESCRIPTION VARCHAR2 (240)
UN Hazard Class Description
NOTE_TO_VENDOR VARCHAR2 (480)
Note to Supplier
POL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Line Attribute Category
POL_ATTRIBUTE1 VARCHAR2 (150)
Line Attribute 1
POL_ATTRIBUTE2 VARCHAR2 (150)
Line Attribute 2
POL_ATTRIBUTE3 VARCHAR2 (150)
Line Attribute 3
POL_ATTRIBUTE4 VARCHAR2 (150)
Line Attribute 4
POL_ATTRIBUTE5 VARCHAR2 (150)
Line Attribute 5
POL_ATTRIBUTE6 VARCHAR2 (150)
Line Attribute 6
POL_ATTRIBUTE7 VARCHAR2 (150)
Line Attribute 7
POL_ATTRIBUTE8 VARCHAR2 (150)
Line Attribute 8
POL_ATTRIBUTE9 VARCHAR2 (150)
Line Attribute 9
POL_ATTRIBUTE10 VARCHAR2 (150)
Line Attribute 10
POL_ATTRIBUTE11 VARCHAR2 (150)
Line Attribute 11
POL_ATTRIBUTE12 VARCHAR2 (150)
Line Attribute 12
POL_ATTRIBUTE13 VARCHAR2 (150)
Line Attribute 13
POL_ATTRIBUTE14 VARCHAR2 (150)
Line Attribute 14
POL_ATTRIBUTE15 VARCHAR2 (150)
Line Attribute 15
MTL_ORGANIZATION_ID NUMBER

Item Organization ID
LP_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Line Part Attribute Category
LP_ATTRIBUTE1 VARCHAR2 (240)
Line Part Attribute 1
LP_ATTRIBUTE2 VARCHAR2 (240)
Line Part Attribute 2
LP_ATTRIBUTE3 VARCHAR2 (240)
Line Part Attribute 3
LP_ATTRIBUTE4 VARCHAR2 (240)
Line Part Attribute 4
LP_ATTRIBUTE5 VARCHAR2 (240)
Line Part Attribute 5
LP_ATTRIBUTE6 VARCHAR2 (240)
Line Part Attribute 6
LP_ATTRIBUTE7 VARCHAR2 (240)
Line Part Attribute 7
LP_ATTRIBUTE8 VARCHAR2 (240)
Line Part Attribute 8
LP_ATTRIBUTE9 VARCHAR2 (240)
Line Part Attribute 9
LP_ATTRIBUTE10 VARCHAR2 (240)
Line Part Attribute 10
LP_ATTRIBUTE11 VARCHAR2 (240)
Line Part Attribute 11
LP_ATTRIBUTE12 VARCHAR2 (240)
Line Part Attribute 12
LP_ATTRIBUTE13 VARCHAR2 (240)
Line Part Attribute 13
LP_ATTRIBUTE14 VARCHAR2 (240)
Line Part Attribute 14
LP_ATTRIBUTE15 VARCHAR2 (240)
Line Part Attribute 15
LP_SEGMENT1 VARCHAR2 (40)
Line Part Segment 1
LP_SEGMENT2 VARCHAR2 (40)
Line Part Segment 2
LP_SEGMENT3 VARCHAR2 (40)
Line Part Segment 3
LP_SEGMENT4 VARCHAR2 (40)
Line Part Segment 4
LP_SEGMENT5 VARCHAR2 (40)
Line Part Segment 5
LP_SEGMENT6 VARCHAR2 (40)
Line Part Segment 6
LP_SEGMENT7 VARCHAR2 (40)
Line Part Segment 7
LP_SEGMENT8 VARCHAR2 (40)
Line Part Segment 8
LP_SEGMENT9 VARCHAR2 (40)
Line Part Segment 9
LP_SEGMENT10 VARCHAR2 (40)
Line Part Segment 10
LP_SEGMENT11 VARCHAR2 (40)
Line Part Segment 11
LP_SEGMENT12 VARCHAR2 (40)
Line Part Segment 12
LP_SEGMENT13 VARCHAR2 (40)
Line Part Segment 13
LP_SEGMENT14 VARCHAR2 (40)
Line Part Segment 14
LP_SEGMENT15 VARCHAR2 (40)
Line Part Segment 15
LP_SEGMENT16 VARCHAR2 (40)
Line Part Segment 16
LP_SEGMENT17 VARCHAR2 (40)
Line Part Segment 17
LP_SEGMENT18 VARCHAR2 (40)
Line Part Segment 18
LP_SEGMENT19 VARCHAR2 (40)
Line Part Segment 19
LP_SEGMENT20 VARCHAR2 (40)
Line Part Segment 20
POR_RELEASE_ID NUMBER

Release ID
POR_RELEASE_NUM NUMBER

Release Number
POR_SOURCE_LINE_NUM NUMBER

Contract Line Number
PO_HEADER_ID NUMBER

Purchase Order Header ID
PO_LINE_ID NUMBER

Purchase Order Line ID
PO_LINE_LOCATION_ID NUMBER

Line Location ID
SHIPMENT_TYPE VARCHAR2 (11)
Shipment Type
EXPIRATION_DATE DATE

Expiration Date
GLOBAL_AGREEMENT_NUM VARCHAR2 (20)
GLOBAL_AGREEMENT_NUM
GLOBAL_AGREEMENT_LINE_NUM NUMBER

GLOBAL_AGREEMENT_LINE_NUM
SUPPLIER_CONFIG_ID VARCHAR2 (150)
SUPPLIER_CONFIG_ID
LINE_TYPE VARCHAR2 (25)
LINE_TYPE
Query Text

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


SELECT LINE_NUM
,      QUANTITY
,      UOM_CODE
,      ITEM_ID
,      ITEM_REVISION
,      VENDOR_PRODUCT_NUMBER
,      UNIT_PRICE
,      ITEM_DESCRIPTION
,      PO_NUMBER
,      VENDOR_QUOTE_NUMBER
,      CANCEL_FLAG
,      CANCEL_DATE
,      QUANTITY_COMMITTED
,      COMMITTED_AMOUNT
,      LIST_PRICE_PER_UNIT
,      MARKET_PRICE
,      NOT_TO_EXCEED_PRICE
,      NEGOTIATED_BY_PREPARER_FLAG
,      TAXABLE_FLAG
,      TRANSACTION_REASON_CODE
,      TYPE_1099
,      ORDER_TYPE_LOOKUP_CODE
,      HAZARD_CLASS
,      UN_NUMBER
,      UN_DESCRIPTION
,      NOTE_TO_VENDOR
,      POL_ATTRIBUTE_CATEGORY
,      POL_ATTRIBUTE1
,      POL_ATTRIBUTE2
,      POL_ATTRIBUTE3
,      POL_ATTRIBUTE4
,      POL_ATTRIBUTE5
,      POL_ATTRIBUTE6
,      POL_ATTRIBUTE7
,      POL_ATTRIBUTE8
,      POL_ATTRIBUTE9
,      POL_ATTRIBUTE10
,      POL_ATTRIBUTE11
,      POL_ATTRIBUTE12
,      POL_ATTRIBUTE13
,      POL_ATTRIBUTE14
,      POL_ATTRIBUTE15
,      MTL_ORGANIZATION_ID
,      LP_ATTRIBUTE_CATEGORY
,      LP_ATTRIBUTE1
,      LP_ATTRIBUTE2
,      LP_ATTRIBUTE3
,      LP_ATTRIBUTE4
,      LP_ATTRIBUTE5
,      LP_ATTRIBUTE6
,      LP_ATTRIBUTE7
,      LP_ATTRIBUTE8
,      LP_ATTRIBUTE9
,      LP_ATTRIBUTE10
,      LP_ATTRIBUTE11
,      LP_ATTRIBUTE12
,      LP_ATTRIBUTE13
,      LP_ATTRIBUTE14
,      LP_ATTRIBUTE15
,      LP_SEGMENT1
,      LP_SEGMENT2
,      LP_SEGMENT3
,      LP_SEGMENT4
,      LP_SEGMENT5
,      LP_SEGMENT6
,      LP_SEGMENT7
,      LP_SEGMENT8
,      LP_SEGMENT9
,      LP_SEGMENT10
,      LP_SEGMENT11
,      LP_SEGMENT12
,      LP_SEGMENT13
,      LP_SEGMENT14
,      LP_SEGMENT15
,      LP_SEGMENT16
,      LP_SEGMENT17
,      LP_SEGMENT18
,      LP_SEGMENT19
,      LP_SEGMENT20
,      POR_RELEASE_ID
,      POR_RELEASE_NUM
,      POR_SOURCE_LINE_NUM
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      SHIPMENT_TYPE
,      EXPIRATION_DATE
,      GLOBAL_AGREEMENT_NUM
,      GLOBAL_AGREEMENT_LINE_NUM
,      SUPPLIER_CONFIG_ID
,      LINE_TYPE
FROM APPS.ECE_POCO_LINES_V;

Dependencies

[top of page]

APPS.ECE_POCO_LINES_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
SynonymMTL_SYSTEM_ITEMS_B
SynonymPO_HAZARD_CLASSES_B
SynonymPO_HAZARD_CLASSES_TL
SynonymPO_HEADERS
SynonymPO_HEADERS_ALL
SynonymPO_LINES
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS
SynonymPO_LINE_TYPES
SynonymPO_RELEASES
SynonymPO_UN_NUMBERS_B
SynonymPO_UN_NUMBERS_TL

APPS.ECE_POCO_LINES_V is not referenced by any database object