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


VIEW: APPS.ICX_POR_REQ_TEMPLATES

Object Details
Object Name: ICX_POR_REQ_TEMPLATES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_POR_REQ_TEMPLATES
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)
CONTRACT_LINE NUMBER

TEMPLATE_ID VARCHAR2 (25)
TEMPLATE_LINE_ID NUMBER

CONTRACT_ID NUMBER

CONTRACT_LINE_ID NUMBER

ITEM_ID NUMBER

ITEM_DESCRIPTION VARCHAR2 (240)
LINE_TYPE_ID NUMBER

CATEGORY_ID NUMBER

UNIT_OF_MEASURE VARCHAR2 (3)
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

INACTIVE_DATE DATE

TYPE_LOOKUP_CODE VARCHAR2 (25)
SOURCE_TYPE_CODE VARCHAR2 (25)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTRACT_NUM
,      CONTRACT_LINE
,      TEMPLATE_ID
,      TEMPLATE_LINE_ID
,      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
,      INACTIVE_DATE
,      TYPE_LOOKUP_CODE
,      SOURCE_TYPE_CODE
FROM APPS.ICX_POR_REQ_TEMPLATES;

Dependencies

[top of page]

APPS.ICX_POR_REQ_TEMPLATES references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymFND_LANGUAGES
SynonymGL_CURRENCIES
ViewGL_SETS_OF_BOOKS
SynonymMTL_UNITS_OF_MEASURE_TL
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_REQEXPRESS_HEADERS_ALL
SynonymPO_REQEXPRESS_LINES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.ICX_POR_REQ_TEMPLATES is not referenced by any database object