[Home] [Help] [Dependency Information]
Object Name: | ICX_POR_PRICE_LIST_LINES_CACH# |
---|---|
Object Type: | VIEW |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
HEADER_ID | NUMBER | Yes | ||
SUPPLIER_ID | NUMBER | Yes | ||
BUYER_ID | NUMBER | Yes | ||
ITEM_ID | NUMBER | Yes | ||
UNIT_PRICE | NUMBER | |||
UOM | VARCHAR2 | (30) | ||
CURRENCY_CODE | VARCHAR2 | (4) | Yes | |
BUYER_APPROVAL_STATUS | VARCHAR2 | (30) | ||
COMMENTS | VARCHAR2 | (2000) | ||
PRICE_CODE | VARCHAR2 | (30) | ||
SUPPLIERCOMMENTS | VARCHAR2 | (2000) | ||
EFFECTIVE_BEGINDATE | DATE | |||
EFFECTIVE_ENDDATE | DATE | |||
BEGINDATE | DATE | |||
ENDDATE | DATE | |||
LIST_NAME | VARCHAR2 | (90) | ||
DB_ACTION | VARCHAR2 | (10) | ||
SESSION_KEY | VARCHAR2 | (250) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT HEADER_ID
, SUPPLIER_ID
, BUYER_ID
, ITEM_ID
, UNIT_PRICE
, UOM
, CURRENCY_CODE
, BUYER_APPROVAL_STATUS
, COMMENTS
, PRICE_CODE
, SUPPLIERCOMMENTS
, EFFECTIVE_BEGINDATE
, EFFECTIVE_ENDDATE
, BEGINDATE
, ENDDATE
, LIST_NAME
, DB_ACTION
, SESSION_KEY
FROM ICX.ICX_POR_PRICE_LIST_LINES_CACH#;
|
|
|