[Home] [Help] [Dependency Information]
Object Name: | ICX_POR_PRICE_LIST_LINES# |
---|---|
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) | ||
BUYER_APPROVAL_DATE | DATE | |||
INACTIVE_DATE | DATE | |||
DESCRIPTION | VARCHAR2 | (2000) | ||
RATE | NUMBER | |||
RATE_TYPE | VARCHAR2 | (25) | ||
RATE_DATE | DATE | |||
BUYER_FUNCTIONAL_CURRENCY | VARCHAR2 | (4) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
SUPPLIER_SITE | VARCHAR2 | (15) | ||
JOB_NUMBER | NUMBER | |||
ACTION | VARCHAR2 | (30) | ||
PUBLISHED_DATE | DATE | |||
OUTDATED_DATE | DATE | |||
DELETED_DATE | DATE | |||
REJECTED_DATE | DATE | |||
COMMENTS | VARCHAR2 | (2000) | ||
PRICE_CODE | VARCHAR2 | (30) | ||
SUPPLIERCOMMENTS | VARCHAR2 | (2000) | ||
PRICE_BREAK_ID | NUMBER | |||
PRICE_BREAK_COUNT | NUMBER | |||
EFFECTIVE_BEGINDATE | DATE | |||
EFFECTIVE_ENDDATE | DATE | |||
BEGINDATE | DATE | |||
ENDDATE | DATE | |||
CONTRACT_REFERENCE_NUM | VARCHAR2 | (20) | ||
CONTRACT_REFERENCE_ID | NUMBER | |||
PAYMENT_TERM | VARCHAR2 | (30) | ||
PRICE_FACTOR | VARCHAR2 | (240) | ||
DEFAULT_FLAG | VARCHAR2 | (1) | ||
OTHER_COMBINATIONS_FLAG | VARCHAR2 | (1) |
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
, BUYER_APPROVAL_DATE
, INACTIVE_DATE
, DESCRIPTION
, RATE
, RATE_TYPE
, RATE_DATE
, BUYER_FUNCTIONAL_CURRENCY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SUPPLIER_SITE
, JOB_NUMBER
, ACTION
, PUBLISHED_DATE
, OUTDATED_DATE
, DELETED_DATE
, REJECTED_DATE
, COMMENTS
, PRICE_CODE
, SUPPLIERCOMMENTS
, PRICE_BREAK_ID
, PRICE_BREAK_COUNT
, EFFECTIVE_BEGINDATE
, EFFECTIVE_ENDDATE
, BEGINDATE
, ENDDATE
, CONTRACT_REFERENCE_NUM
, CONTRACT_REFERENCE_ID
, PAYMENT_TERM
, PRICE_FACTOR
, DEFAULT_FLAG
, OTHER_COMBINATIONS_FLAG
FROM ICX.ICX_POR_PRICE_LIST_LINES#;
|
|
|