[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ITG_PO_LINE_ARCH_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ITG.ITG_PO_LINE_ARCH_V
|
| Subobject Name: | |
| Status: | VALID |
Used for XML mapping in the line level
| Name | Datatype | Length | Mandatory | 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 | (20) | ||
| 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 | |||
| SUPPLIER_REF_NUMBER | VARCHAR2 | (150) | Configuration ID for the ordered item' | |
| POLNSTATUS | VARCHAR2 | (9) | ||
| JOBTITLE | VARCHAR2 | (700) | ||
| CONTRACTORFIRSTNAME | VARCHAR2 | (240) | ||
| CONTRACTORLASTNAME | VARCHAR2 | (240) | ||
| STARTDATE | DATE | |||
| ENDDATE | DATE | |||
| AMOUNT_SERVICES | NUMBER |
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
, JOBTITLE
, CONTRACTORFIRSTNAME
, CONTRACTORLASTNAME
, STARTDATE
, ENDDATE
, AMOUNT_SERVICES
FROM APPS.ITG_PO_LINE_ARCH_V;
APPS
FINANCIALS_SYSTEM_PARAMS_ALL
MTL_CATEGORIES_KFV
MTL_SYSTEM_ITEMS_B_KFV
MTL_UNITS_OF_MEASURE_TL
PER_JOBS
PO_DISTINCT_RELID_LINEID_V
PO_HAZARD_CLASSES
PO_HEADERS_ALL
PO_LINES_ARCHIVE_ALL
PO_LINE_TYPES
PO_UN_NUMBERS_TL
APPS.ITG_PO_LINE_ARCH_V is not referenced by any database object
|
|
|
|