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


VIEW: APPS.ICX_POR_REQ_INACTIVE_CONTRACTS

Object Details
Object Name: ICX_POR_REQ_INACTIVE_CONTRACTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_POR_REQ_INACTIVE_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

CATEGORY_ID NUMBER

UNIT_OF_MEASURE VARCHAR2 (25)
UNIT_PRICE NUMBER

CURRENCY VARCHAR2 (15) Yes
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_PART_NUMBER VARCHAR2 (25)
OPERATING_UNIT_ID NUMBER

CREATION_DATE DATE

LAST_UPDATE_ATE 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
,      UNIT_PRICE
,      CURRENCY
,      CONTRACT_PRICE
,      CONTRACT_CURRENCY
,      CONTRACT_RATE_TYPE
,      CONTRACT_RATE_DATE
,      CONTRACT_RATE
,      PICTURE_URL
,      SUPPLIER
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_PART_NUMBER
,      OPERATING_UNIT_ID
,      CREATION_DATE
,      LAST_UPDATE_ATE
FROM APPS.ICX_POR_REQ_INACTIVE_CONTRACTS;

Dependencies

[top of page]

APPS.ICX_POR_REQ_INACTIVE_CONTRACTS references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymGL_DAILY_CONVERSION_TYPES
ViewGL_SETS_OF_BOOKS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_F
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_TYPES
ViewPO_VENDORS

APPS.ICX_POR_REQ_INACTIVE_CONTRACTS is not referenced by any database object