DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.ICX_POR_EXT_CONTRACTS

Object Details
Object Name: ICX_POR_EXT_CONTRACTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_POR_EXT_CONTRACTS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.ICX_POR_EXT_CONTRACTS references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymFND_LANGUAGES
SynonymGL_CURRENCIES
SynonymMTL_UNITS_OF_MEASURE_TL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.ICX_POR_EXT_CONTRACTS is not referenced by any database object