[Home] [Help] [Dependency Information]

VIEW: APPS.ICX_POR_REQ_CONTRACTS

Object Details

Object Name:	ICX_POR_REQ_CONTRACTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.ICX_POR_REQ_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

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_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
,      AGENT_START_DATE
,      AGENT_END_DATE
,      EXPIRATION_DATE
FROM APPS.ICX_POR_REQ_CONTRACTS;

Dependencies

[top of page]

APPS

FINANCIALS_SYSTEM_PARAMS_ALL

GL_DAILY_CONVERSION_TYPES

GL_SETS_OF_BOOKS

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

MTL_UNITS_OF_MEASURE_TL

PER_PEOPLE_F

PO_HEADERS_ALL

PO_LINES_ALL

PO_VENDORS

APPS.ICX_POR_REQ_CONTRACTS is not referenced by any database object