[Home] [Help] [Dependency Information]
Object Name: | ICX_POR_CONTRACT_REFERENCES# |
---|---|
Object Type: | VIEW |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
JOB_NUMBER | NUMBER | Yes | ||
LINE_NUMBER | NUMBER | Yes | ||
BUYER_ID | NUMBER | |||
BUYER_NAME | VARCHAR2 | (240) | ||
CONTRACT_REFERENCE_ID | NUMBER | |||
CONTRACT_REFERENCE_NUM | VARCHAR2 | (20) | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_SITE | VARCHAR2 | (15) | ||
PRICELIST_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
ERROR_MESSAGE | VARCHAR2 | (2000) | ||
REQUEST_ID | NUMBER | Yes | ||
SUPPLIER_SITE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT JOB_NUMBER
, LINE_NUMBER
, BUYER_ID
, BUYER_NAME
, CONTRACT_REFERENCE_ID
, CONTRACT_REFERENCE_NUM
, SUPPLIER_ID
, SUPPLIER_SITE
, PRICELIST_ID
, CURRENCY_CODE
, ERROR_MESSAGE
, REQUEST_ID
, SUPPLIER_SITE_ID
FROM ICX.ICX_POR_CONTRACT_REFERENCES#;
|
|
|