[Home] [Help] [Dependency Information]
Object Name: | ICX_POR_EXT_CONTRACTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_POR_EXT_CONTRACTS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTRACT_NUM | VARCHAR2 | (20) | Yes | |
CONTRACT_LINE | NUMBER | Yes | ||
CONTRACT_ID | NUMBER | Yes | ||
CONTRACT_LINE_ID | NUMBER | Yes | ||
ITEM_ID | NUMBER | |||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
LINE_TYPE_ID | NUMBER | Yes | ||
CATEGORY_ID | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (3) | Yes | |
FUNCTIONAL_PRICE | NUMBER | |||
CURRENCY | VARCHAR2 | (15) | ||
CONTRACT_PRICE | NUMBER | |||
CONTRACT_CURRENCY | VARCHAR2 | (15) | ||
CONTRACT_RATE_TYPE | VARCHAR2 | (30) | ||
CONTRACT_RATE_DATE | DATE | |||
CONTRACT_RATE | NUMBER | |||
PICTURE_URL | VARCHAR2 | (150) | ||
SUPPLIER | VARCHAR2 | (240) | ||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_SITE_ID | NUMBER | |||
SUPPLIER_SITE_CODE | VARCHAR2 | (15) | Supplier Site Code | |
SUPPLIER_PART_NUMBER | VARCHAR2 | (25) | ||
OPERATING_UNIT_ID | NUMBER | |||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
CONTRACT_APPROVED_DATE | DATE | |||
CONTRACT_APPROVED_FLAG | VARCHAR2 | (1) | ||
CONTRACT_CANCEL_FLAG | VARCHAR2 | (1) | ||
CONTRACT_FROZEN_FLAG | VARCHAR2 | (1) | ||
CONTRACT_CLOSED_CODE | VARCHAR2 | (25) | ||
CONTRACT_LINE_CLOSED_CODE | VARCHAR2 | (25) | ||
CONTRACT_LINE_CANCEL_FLAG | VARCHAR2 | (1) | ||
CONTRACT_STATUS_LOOKUP_CODE | VARCHAR2 | (25) | ||
CONTRACT_QUOTATION_CLASS_CODE | VARCHAR2 | (25) | ||
CONTRACT_START_DATE | DATE | |||
CONTRACT_END_DATE | DATE | |||
AGENT_ID | NUMBER | (9) | Yes | |
EXPIRATION_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT CONTRACT_NUM
, CONTRACT_LINE
, CONTRACT_ID
, CONTRACT_LINE_ID
, ITEM_ID
, ITEM_DESCRIPTION
, LINE_TYPE_ID
, CATEGORY_ID
, UNIT_OF_MEASURE
, FUNCTIONAL_PRICE
, CURRENCY
, CONTRACT_PRICE
, CONTRACT_CURRENCY
, CONTRACT_RATE_TYPE
, CONTRACT_RATE_DATE
, CONTRACT_RATE
, PICTURE_URL
, SUPPLIER
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, SUPPLIER_SITE_CODE
, SUPPLIER_PART_NUMBER
, OPERATING_UNIT_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, CONTRACT_APPROVED_DATE
, CONTRACT_APPROVED_FLAG
, CONTRACT_CANCEL_FLAG
, CONTRACT_FROZEN_FLAG
, CONTRACT_CLOSED_CODE
, CONTRACT_LINE_CLOSED_CODE
, CONTRACT_LINE_CANCEL_FLAG
, CONTRACT_STATUS_LOOKUP_CODE
, CONTRACT_QUOTATION_CLASS_CODE
, CONTRACT_START_DATE
, CONTRACT_END_DATE
, AGENT_ID
, EXPIRATION_DATE
FROM APPS.ICX_POR_EXT_CONTRACTS;
APPS.ICX_POR_EXT_CONTRACTS is not referenced by any database object
|
|
|