[Home] [Help] [Dependency Information]

TABLE: EC.ECE_PO_INTERFACE_LINES

Object Details

Object Name:	ECE_PO_INTERFACE_LINES
Object Type:	TABLE
Owner:	EC
FND Design Data:	EC.ECE_PO_INTERFACE_LINES
Subobject Name:
Status:	VALID

ECE_PO_INTERFACE_LINES contains purchase order line data to support
the outbound Purchase Order (850/ORDERS) and Purchase Order Change
(860/ORDCHG) transactions.

ECE_PO_INTERFACE_LINES is based primarily on data stored in PO_LINES
and PO_LINE_LOCATIONS in Oracle Purchasing. ECE_PO_INTERFACE_LINES
contains approved purchase orders or purchase order changes that match
the e-Commerce Gateway users extract selection criteria.

Each row includes the line number, item number, unit price, tax data,
and quantity ordered. The purchase order line quantity represents the
total quantity for all purchase order shipment lines maintained in
ECE_PO_INTERFACE_SHIPMENTS.

Each row in ECE_PO_INTERFACE_LINES is associated with one row in
ECE_PO_INTERFACE_HEADERS. There is a one-to-many relationship between
ECE_PO_INTERFACE_HEADERS and ECE_PO_INTERFACE_LINES.

RUN_ID uniquely identifies the session that created the row in
ECE_PO_INTERFACE_LINES since this table is shared by two transactions.

Due to the difference in the Oracle Purchasing data model for blanket
releases and all other purchase order types, each blanket release
shipment line is stored as a purchase order line and purchase order
shipment. This is for easy mapping to the ASC X12 PO1 line segment
since the ASC X12 SCH schedule segment does not accommodate
prices at the shipment level within the name/address loop.

Both ITEM_ID from PO_LINES and the 20 segment part numbers maintained
in LINE_PART_SEGMENT_(1-20) from MTL_ITEM_FLEXFIELDS are available.

All columns denoted with "Int" or "Internal" represent Oracle
Applications internal values. All columns denoted with "Ext" or
"External" represent the equivalent external values sourced from the
ECE_XREF_DATA table if code conversion is enabled for the column.

Each row in ECE_PO_INTERFACE_LINES is purged after the data is
written to the data file.

TRANSACTION_RECORD_ID is the unique key that links the
ECE_PO_INTERFACE_LINES table to its corresponding extension table
ECE_PO_INTERFACE_LINES_X.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ECE_PO_INTERFACE_LINES_U2	NORMAL	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_RECORD_ID
ECE_PO_INTERFACE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	RUN_ID

Columns

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 does not reference any database object

EC.ECE_PO_INTERFACE_LINES is referenced by following:

APPS

ECE_PO_INTERFACE_LINES