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.PO_ECX_LINE_ARCH_V

Object Details

Object Name:	PO_ECX_LINE_ARCH_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_ECX_LINE_ARCH_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	Comments
PO_HEADER_ID	NUMBER
LINE_NUM	NUMBER
PO_LINE_ID	NUMBER
REVISION_NUM	NUMBER
RELEASE_ID	NUMBER
QUANTITY	NUMBER
QUANT_UOM	VARCHAR2	(3)
ITEMX	VARCHAR2	(25)
ITEM	VARCHAR2	(40)
DESCRIPTION	VARCHAR2	(240)
HAZRDMTL	VARCHAR2	(40)
ITEMRV	VARCHAR2	(3)
NOTE_TO_VENDOR	VARCHAR2	(480)
PRICE	NUMBER
UNIT	CHAR	(4)
CATEGORYID	VARCHAR2	(163)
CONTRACT	VARCHAR2	(25)
TASKID	NUMBER
PROJECTID	NUMBER
CONTRACT_NUM	VARCHAR2	(25)
VENDORQUOTENUM	VARCHAR2	(25)
LISTPRICE	NUMBER
MARKETPRICE	NUMBER
PRICENOTTOEXCEED	NUMBER
NEGPRICE	VARCHAR2	(1)
TAXABLE	VARCHAR2	(1)
TXNREASONCODE	VARCHAR2	(25)
TYPE1099	VARCHAR2	(10)
LINEORDERTYPE	VARCHAR2	(25)
HAZRDUNNUM	VARCHAR2	(25)
HAZRDUNDESC	VARCHAR2	(240)
DFF_LINE_ATTR1	VARCHAR2	(150)
DFF_LINE_ATTR2	VARCHAR2	(150)
DFF_LINE_ATTR3	VARCHAR2	(150)
DFF_LINE_ATTR4	VARCHAR2	(150)
DFF_LINE_ATTR5	VARCHAR2	(150)
DFF_LINE_ATTR6	VARCHAR2	(150)
DFF_LINE_ATTR7	VARCHAR2	(150)
DFF_LINE_ATTR8	VARCHAR2	(150)
DFF_LINE_ATTR9	VARCHAR2	(150)
DFF_LINE_ATTR10	VARCHAR2	(150)
DFF_LINE_ATTR11	VARCHAR2	(150)
DFF_LINE_ATTR12	VARCHAR2	(150)
DFF_LINE_ATTR13	VARCHAR2	(150)
DFF_LINE_ATTR14	VARCHAR2	(150)
DFF_LINE_ATTR15	VARCHAR2	(150)
DFF_LINE_ATTR16	VARCHAR2	(30)
DFF_ITEM_ATTR1	VARCHAR2	(150)
DFF_ITEM_ATTR2	VARCHAR2	(150)
DFF_ITEM_ATTR3	VARCHAR2	(150)
DFF_ITEM_ATTR4	VARCHAR2	(150)
DFF_ITEM_ATTR5	VARCHAR2	(150)
DFF_ITEM_ATTR6	VARCHAR2	(150)
DFF_ITEM_ATTR7	VARCHAR2	(150)
DFF_ITEM_ATTR8	VARCHAR2	(150)
DFF_ITEM_ATTR9	VARCHAR2	(150)
DFF_ITEM_ATTR10	VARCHAR2	(150)
DFF_ITEM_ATTR11	VARCHAR2	(150)
DFF_ITEM_ATTR12	VARCHAR2	(150)
DFF_ITEM_ATTR13	VARCHAR2	(150)
DFF_ITEM_ATTR14	VARCHAR2	(150)
DFF_ITEM_ATTR15	VARCHAR2	(150)
DFF_ITEM_ATTR16	VARCHAR2	(30)
KFF_ITEM_ATTR1	VARCHAR2	(40)
KFF_ITEM_ATTR2	VARCHAR2	(40)
KFF_ITEM_ATTR3	VARCHAR2	(40)
KFF_ITEM_ATTR4	VARCHAR2	(40)
KFF_ITEM_ATTR5	VARCHAR2	(40)
KFF_ITEM_ATTR6	VARCHAR2	(40)
KFF_ITEM_ATTR7	VARCHAR2	(40)
KFF_ITEM_ATTR8	VARCHAR2	(40)
KFF_ITEM_ATTR9	VARCHAR2	(40)
KFF_ITEM_ATTR10	VARCHAR2	(40)
KFF_ITEM_ATTR11	VARCHAR2	(40)
KFF_ITEM_ATTR12	VARCHAR2	(40)
KFF_ITEM_ATTR13	VARCHAR2	(40)
KFF_ITEM_ATTR14	VARCHAR2	(40)
KFF_ITEM_ATTR15	VARCHAR2	(40)
KFF_ITEM_ATTR16	VARCHAR2	(40)
KFF_ITEM_ATTR17	VARCHAR2	(40)
KFF_ITEM_ATTR18	VARCHAR2	(40)
KFF_ITEM_ATTR19	VARCHAR2	(40)
KFF_ITEM_ATTR20	VARCHAR2	(40)
ITEMRVX	VARCHAR2	(3)
LATEST_EXTERNAL_FLAG	VARCHAR2	(1)	Flag indicating the latest revision of the po line.
CONTRACT_ID	NUMBER		Contract id
SUPPLIER_REF_NUMBER	VARCHAR2	(150)	Configuration ID for the ordered item
POLNSTATUS	VARCHAR2	(9)

Query Text

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


SELECT PO_HEADER_ID
,      LINE_NUM
,      PO_LINE_ID
,      REVISION_NUM
,      RELEASE_ID
,      QUANTITY
,      QUANT_UOM
,      ITEMX
,      ITEM
,      DESCRIPTION
,      HAZRDMTL
,      ITEMRV
,      NOTE_TO_VENDOR
,      PRICE
,      UNIT
,      CATEGORYID
,      CONTRACT
,      TASKID
,      PROJECTID
,      CONTRACT_NUM
,      VENDORQUOTENUM
,      LISTPRICE
,      MARKETPRICE
,      PRICENOTTOEXCEED
,      NEGPRICE
,      TAXABLE
,      TXNREASONCODE
,      TYPE1099
,      LINEORDERTYPE
,      HAZRDUNNUM
,      HAZRDUNDESC
,      DFF_LINE_ATTR1
,      DFF_LINE_ATTR2
,      DFF_LINE_ATTR3
,      DFF_LINE_ATTR4
,      DFF_LINE_ATTR5
,      DFF_LINE_ATTR6
,      DFF_LINE_ATTR7
,      DFF_LINE_ATTR8
,      DFF_LINE_ATTR9
,      DFF_LINE_ATTR10
,      DFF_LINE_ATTR11
,      DFF_LINE_ATTR12
,      DFF_LINE_ATTR13
,      DFF_LINE_ATTR14
,      DFF_LINE_ATTR15
,      DFF_LINE_ATTR16
,      DFF_ITEM_ATTR1
,      DFF_ITEM_ATTR2
,      DFF_ITEM_ATTR3
,      DFF_ITEM_ATTR4
,      DFF_ITEM_ATTR5
,      DFF_ITEM_ATTR6
,      DFF_ITEM_ATTR7
,      DFF_ITEM_ATTR8
,      DFF_ITEM_ATTR9
,      DFF_ITEM_ATTR10
,      DFF_ITEM_ATTR11
,      DFF_ITEM_ATTR12
,      DFF_ITEM_ATTR13
,      DFF_ITEM_ATTR14
,      DFF_ITEM_ATTR15
,      DFF_ITEM_ATTR16
,      KFF_ITEM_ATTR1
,      KFF_ITEM_ATTR2
,      KFF_ITEM_ATTR3
,      KFF_ITEM_ATTR4
,      KFF_ITEM_ATTR5
,      KFF_ITEM_ATTR6
,      KFF_ITEM_ATTR7
,      KFF_ITEM_ATTR8
,      KFF_ITEM_ATTR9
,      KFF_ITEM_ATTR10
,      KFF_ITEM_ATTR11
,      KFF_ITEM_ATTR12
,      KFF_ITEM_ATTR13
,      KFF_ITEM_ATTR14
,      KFF_ITEM_ATTR15
,      KFF_ITEM_ATTR16
,      KFF_ITEM_ATTR17
,      KFF_ITEM_ATTR18
,      KFF_ITEM_ATTR19
,      KFF_ITEM_ATTR20
,      ITEMRVX
,      LATEST_EXTERNAL_FLAG
,      CONTRACT_ID
,      SUPPLIER_REF_NUMBER
,      POLNSTATUS
FROM APPS.PO_ECX_LINE_ARCH_V;

Dependencies

[top of page]

APPS.PO_ECX_LINE_ARCH_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMS_ALL; MTL_CATEGORIES_KFV; MTL_SYSTEM_ITEMS_B_KFV; MTL_UNITS_OF_MEASURE_TL; PO_DISTINCT_RELID_LINEID_V; PO_HAZARD_CLASSES; PO_HEADERS_ALL; PO_LINES_ARCHIVE_ALL; PO_LINE_TYPES; PO_UN_NUMBERS_TL

APPS.PO_ECX_LINE_ARCH_V is not referenced by any database object