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: EC.ECE_PO_INTERFACE_LINES#

Object Details

Object Name:	ECE_PO_INTERFACE_LINES#
Object Type:	VIEW
Owner:	EC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
LINE_NUMBER	NUMBER
LINE_ORDER_QUANTITY	NUMBER
LINE_UOM	VARCHAR2	(25)
LINE_UOM_EXT1	VARCHAR2	(80)
ITEM_ID	NUMBER
LINE_REVISION_NUMBER	VARCHAR2	(3)
VENDOR_PRODUCT_NUMBER	VARCHAR2	(25)
LINE_UNIT_PRICE	NUMBER
LINE_ITEM_DESCRIPTION	VARCHAR2	(240)
CONTRACT_PO_NUMBER	VARCHAR2	(20)
VENDOR_QUOTE_NUMBER	VARCHAR2	(25)
LINE_CANCELLED_FLAG	VARCHAR2	(1)
LINE_CANCELLED_DATE	DATE
BLANKET_QUANTITY_COMMITTED	NUMBER
BLANKET_AMOUNT_COMMITTED	NUMBER
LINE_LIST_PRICE	NUMBER
LINE_MARKET_PRICE	NUMBER
LINE_UNIT_PRICE_NOT_TO_EXCEED	NUMBER
NEGOTIATED_PRICE_FLAG	VARCHAR2	(1)
LINE_TAXABLE_FLAG	VARCHAR2	(1)
LINE_TAXABLE_FLAG_EXT1	VARCHAR2	(80)
TRANSACTION_REASON_CODE	VARCHAR2	(25)
TYPE_1099	VARCHAR2	(10)
LINE_ORDER_TYPE	VARCHAR2	(25)
LINE_ITEM_HAZARD_CLASS	VARCHAR2	(40)
UN_HAZARD_CLASS_NUMBER	VARCHAR2	(25)
UN_HAZARD_CLASS_DESCRIPTION	VARCHAR2	(240)
LINE_NOTE_TO_VENDOR	VARCHAR2	(480)
PO_NUMBER	VARCHAR2	(20)
PO_TYPE	VARCHAR2	(25)
RELEASE_NUMBER	NUMBER
QUOTE_NUMBER	VARCHAR2	(20)
QUOTE_LINE_NUMBER	NUMBER
LINE_PART_NUMBER	VARCHAR2	(100)
LINE_PART_ATTRIB_CATEGORY	VARCHAR2	(30)
LINE_PART_ATTRIBUTE1	VARCHAR2	(150)
LINE_PART_ATTRIBUTE2	VARCHAR2	(150)
LINE_PART_ATTRIBUTE3	VARCHAR2	(150)
LINE_PART_ATTRIBUTE4	VARCHAR2	(150)
LINE_PART_ATTRIBUTE5	VARCHAR2	(150)
LINE_PART_ATTRIBUTE6	VARCHAR2	(150)
LINE_PART_ATTRIBUTE7	VARCHAR2	(150)
LINE_PART_ATTRIBUTE8	VARCHAR2	(150)
LINE_PART_ATTRIBUTE9	VARCHAR2	(150)
LINE_PART_ATTRIBUTE10	VARCHAR2	(150)
LINE_PART_ATTRIBUTE11	VARCHAR2	(150)
LINE_PART_ATTRIBUTE12	VARCHAR2	(150)
LINE_PART_ATTRIBUTE13	VARCHAR2	(150)
LINE_PART_ATTRIBUTE14	VARCHAR2	(150)
LINE_PART_ATTRIBUTE15	VARCHAR2	(150)
LINE_ATTRIBUTE_CATEGORY	VARCHAR2	(30)
LINE_ATTRIBUTE1	VARCHAR2	(150)
LINE_ATTRIBUTE2	VARCHAR2	(150)
LINE_ATTRIBUTE3	VARCHAR2	(150)
LINE_ATTRIBUTE4	VARCHAR2	(150)
LINE_ATTRIBUTE5	VARCHAR2	(150)
LINE_ATTRIBUTE6	VARCHAR2	(150)
LINE_ATTRIBUTE7	VARCHAR2	(150)
LINE_ATTRIBUTE8	VARCHAR2	(150)
LINE_ATTRIBUTE9	VARCHAR2	(150)
LINE_ATTRIBUTE10	VARCHAR2	(150)
LINE_ATTRIBUTE11	VARCHAR2	(150)
LINE_ATTRIBUTE12	VARCHAR2	(150)
LINE_ATTRIBUTE13	VARCHAR2	(150)
LINE_ATTRIBUTE14	VARCHAR2	(150)
LINE_ATTRIBUTE15	VARCHAR2	(150)
LINE_UOM_EXT2	VARCHAR2	(80)
LINE_UOM_EXT3	VARCHAR2	(80)
LINE_UOM_EXT4	VARCHAR2	(80)
LINE_UOM_EXT5	VARCHAR2	(80)
LINE_TAXABLE_FLAG_EXT2	VARCHAR2	(80)
LINE_TAXABLE_FLAG_EXT3	VARCHAR2	(80)
LINE_TAXABLE_FLAG_EXT4	VARCHAR2	(80)
LINE_TAXABLE_FLAG_EXT5	VARCHAR2	(1)
PO_HEADER_ID	NUMBER
PO_RELEASE_ID	NUMBER
PO_LINE_ID	NUMBER
PO_LINE_LOCATION_ID	NUMBER
TRANSACTION_RECORD_ID	NUMBER
RUN_ID	NUMBER
TRANSACTION_TYPE	VARCHAR2	(3)
COMMUNICATION_METHOD	VARCHAR2	(30)
CREATION_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
CONTRACT_PO_LINE_NUMBER	NUMBER
LINE_PART_SEGMENT1	VARCHAR2	(40)
LINE_PART_SEGMENT2	VARCHAR2	(40)
LINE_PART_SEGMENT3	VARCHAR2	(40)
LINE_PART_SEGMENT4	VARCHAR2	(40)
LINE_PART_SEGMENT5	VARCHAR2	(40)
LINE_PART_SEGMENT6	VARCHAR2	(40)
LINE_PART_SEGMENT7	VARCHAR2	(40)
LINE_PART_SEGMENT8	VARCHAR2	(40)
LINE_PART_SEGMENT9	VARCHAR2	(40)
LINE_PART_SEGMENT10	VARCHAR2	(40)
LINE_PART_SEGMENT11	VARCHAR2	(40)
LINE_PART_SEGMENT12	VARCHAR2	(40)
LINE_PART_SEGMENT13	VARCHAR2	(40)
LINE_PART_SEGMENT14	VARCHAR2	(40)
LINE_PART_SEGMENT15	VARCHAR2	(40)
LINE_PART_SEGMENT16	VARCHAR2	(40)
LINE_PART_SEGMENT17	VARCHAR2	(40)
LINE_PART_SEGMENT18	VARCHAR2	(40)
LINE_PART_SEGMENT19	VARCHAR2	(40)
LINE_PART_SEGMENT20	VARCHAR2	(40)
LINE_STATUS_CODE	VARCHAR2	(40)
LINE_STATUS_CODE_EXT1	VARCHAR2	(40)
LINE_STATUS_CODE_EXT2	VARCHAR2	(40)
LINE_STATUS_CODE_EXT3	VARCHAR2	(40)
LINE_STATUS_CODE_EXT4	VARCHAR2	(40)
LINE_STATUS_CODE_EXT5	VARCHAR2	(40)
POR_RELEASE_ID	NUMBER
MTL_ORGANIZATION_ID	NUMBER	(22)
EXPIRATION_DATE	DATE
LINE_ITEM_DESCRIPTION_LONG	VARCHAR2	(240)
GLOBAL_AGREEMENT_NUM	VARCHAR2	(20)
GLOBAL_AGREEMENT_LINE_NUM	NUMBER
SUPPLIER_CONFIG_ID	VARCHAR2	(150)

Query Text

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


SELECT LINE_NUMBER
,      LINE_ORDER_QUANTITY
,      LINE_UOM
,      LINE_UOM_EXT1
,      ITEM_ID
,      LINE_REVISION_NUMBER
,      VENDOR_PRODUCT_NUMBER
,      LINE_UNIT_PRICE
,      LINE_ITEM_DESCRIPTION
,      CONTRACT_PO_NUMBER
,      VENDOR_QUOTE_NUMBER
,      LINE_CANCELLED_FLAG
,      LINE_CANCELLED_DATE
,      BLANKET_QUANTITY_COMMITTED
,      BLANKET_AMOUNT_COMMITTED
,      LINE_LIST_PRICE
,      LINE_MARKET_PRICE
,      LINE_UNIT_PRICE_NOT_TO_EXCEED
,      NEGOTIATED_PRICE_FLAG
,      LINE_TAXABLE_FLAG
,      LINE_TAXABLE_FLAG_EXT1
,      TRANSACTION_REASON_CODE
,      TYPE_1099
,      LINE_ORDER_TYPE
,      LINE_ITEM_HAZARD_CLASS
,      UN_HAZARD_CLASS_NUMBER
,      UN_HAZARD_CLASS_DESCRIPTION
,      LINE_NOTE_TO_VENDOR
,      PO_NUMBER
,      PO_TYPE
,      RELEASE_NUMBER
,      QUOTE_NUMBER
,      QUOTE_LINE_NUMBER
,      LINE_PART_NUMBER
,      LINE_PART_ATTRIB_CATEGORY
,      LINE_PART_ATTRIBUTE1
,      LINE_PART_ATTRIBUTE2
,      LINE_PART_ATTRIBUTE3
,      LINE_PART_ATTRIBUTE4
,      LINE_PART_ATTRIBUTE5
,      LINE_PART_ATTRIBUTE6
,      LINE_PART_ATTRIBUTE7
,      LINE_PART_ATTRIBUTE8
,      LINE_PART_ATTRIBUTE9
,      LINE_PART_ATTRIBUTE10
,      LINE_PART_ATTRIBUTE11
,      LINE_PART_ATTRIBUTE12
,      LINE_PART_ATTRIBUTE13
,      LINE_PART_ATTRIBUTE14
,      LINE_PART_ATTRIBUTE15
,      LINE_ATTRIBUTE_CATEGORY
,      LINE_ATTRIBUTE1
,      LINE_ATTRIBUTE2
,      LINE_ATTRIBUTE3
,      LINE_ATTRIBUTE4
,      LINE_ATTRIBUTE5
,      LINE_ATTRIBUTE6
,      LINE_ATTRIBUTE7
,      LINE_ATTRIBUTE8
,      LINE_ATTRIBUTE9
,      LINE_ATTRIBUTE10
,      LINE_ATTRIBUTE11
,      LINE_ATTRIBUTE12
,      LINE_ATTRIBUTE13
,      LINE_ATTRIBUTE14
,      LINE_ATTRIBUTE15
,      LINE_UOM_EXT2
,      LINE_UOM_EXT3
,      LINE_UOM_EXT4
,      LINE_UOM_EXT5
,      LINE_TAXABLE_FLAG_EXT2
,      LINE_TAXABLE_FLAG_EXT3
,      LINE_TAXABLE_FLAG_EXT4
,      LINE_TAXABLE_FLAG_EXT5
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      TRANSACTION_RECORD_ID
,      RUN_ID
,      TRANSACTION_TYPE
,      COMMUNICATION_METHOD
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CONTRACT_PO_LINE_NUMBER
,      LINE_PART_SEGMENT1
,      LINE_PART_SEGMENT2
,      LINE_PART_SEGMENT3
,      LINE_PART_SEGMENT4
,      LINE_PART_SEGMENT5
,      LINE_PART_SEGMENT6
,      LINE_PART_SEGMENT7
,      LINE_PART_SEGMENT8
,      LINE_PART_SEGMENT9
,      LINE_PART_SEGMENT10
,      LINE_PART_SEGMENT11
,      LINE_PART_SEGMENT12
,      LINE_PART_SEGMENT13
,      LINE_PART_SEGMENT14
,      LINE_PART_SEGMENT15
,      LINE_PART_SEGMENT16
,      LINE_PART_SEGMENT17
,      LINE_PART_SEGMENT18
,      LINE_PART_SEGMENT19
,      LINE_PART_SEGMENT20
,      LINE_STATUS_CODE
,      LINE_STATUS_CODE_EXT1
,      LINE_STATUS_CODE_EXT2
,      LINE_STATUS_CODE_EXT3
,      LINE_STATUS_CODE_EXT4
,      LINE_STATUS_CODE_EXT5
,      POR_RELEASE_ID
,      MTL_ORGANIZATION_ID
,      EXPIRATION_DATE
,      LINE_ITEM_DESCRIPTION_LONG
,      GLOBAL_AGREEMENT_NUM
,      GLOBAL_AGREEMENT_LINE_NUM
,      SUPPLIER_CONFIG_ID
FROM EC.ECE_PO_INTERFACE_LINES#;

Dependencies

[top of page]

EC.ECE_PO_INTERFACE_LINES# references the following:

EC: ECE_PO_INTERFACE_LINES

EC.ECE_PO_INTERFACE_LINES# is referenced by following:

APPS: ECE_PO_INTERFACE_LINES