eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.ICX_PO_REQ_TEMPLATE_ITEMS_V

Object Details

Object Name:	ICX_PO_REQ_TEMPLATE_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.ICX_PO_REQ_TEMPLATE_ITEMS_V
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	Comments
EXPRESS_NAME	VARCHAR2	(25)
LINE_ID	VARCHAR2	(65)	Line unique identifier
TYPE_LOOKUP_CODE	VARCHAR2	(25)
DOCUMENT_TYPE	VARCHAR2	(80)
DESCRIPTION	VARCHAR2	(240)
SEQUENCE_NUM	NUMBER
SOURCE_DOC_HEADER_ID	VARCHAR2	(40)
SOURCE_DOC_NUM	VARCHAR2	(20)
SOURCE_DOC_TYPE_CODE	VARCHAR2	(25)
SOURCE_DOC_TYPE	VARCHAR2	(80)
SOURCE_DOC_CURRENCY	VARCHAR2	(15)
SOURCE_DOC_RATE	NUMBER
SOURCE_DOC_RATE_TYPE	VARCHAR2	(30)
SOURCE_DOC_RATE_TYPE_DSP	VARCHAR2	(30)
SOURCE_DOC_RATE_DATE	DATE
SOURCE_DOC_FUNCTIONAL_CURRENCY	VARCHAR2	(15)
SOURCE_DOC_LINE_ID	NUMBER
SOURCE_DOC_LINE_NUM	VARCHAR2	(40)
SOURCE_DOC_CURRENCY_PRICE	NUMBER
SOURCE_DOC_BASE_PRICE	NUMBER		Unit price (rated)
ITEM_ID	VARCHAR2	(40)
ITEM_DESCRIPTION	VARCHAR2	(240)
PRICE	NUMBER		Extended unit price (rated)
LINE_TYPE_ID	VARCHAR2	(40)
LINE_TYPE	VARCHAR2	(25)
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	VARCHAR2	(40)
UOM	VARCHAR2	(25)
TEMPLATE_LINE_PRICE	NUMBER
SUGGESTED_SOURCE_ID	NUMBER
SOURCE_NAME	VARCHAR2	(240)
SUGGESTED_VENDOR_SITE_ID	NUMBER
VENDOR_SITE_CODE	VARCHAR2	(15)
SUGGESTED_VENDOR_CONTACT_ID	NUMBER
VENDOR_CONTACT_NAME	VARCHAR2	(32)	Supplier contact name
SUGGESTED_VENDOR_PRODUCT_CODE	VARCHAR2	(25)
SUGGESTED_BUYER_ID	NUMBER	(9)
BUYER_NAME	VARCHAR2	(240)
RFQ_REQUIRED_FLAG	VARCHAR2	(1)
SOURCE_TYPE_CODE	VARCHAR2	(25)
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)
ORDER_TYPE_LOOKUP_DSP	VARCHAR2	(80)
ITEM_NUMBER	VARCHAR2	(40)
ORGANIZATION_ID	NUMBER
SUPPLIER_URL	VARCHAR2	(150)
SUPPLIER_ITEM_URL	VARCHAR2	(240)
ITEM_URL	VARCHAR2	(240)

Query Text

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


SELECT EXPRESS_NAME
,      LINE_ID
,      TYPE_LOOKUP_CODE
,      DOCUMENT_TYPE
,      DESCRIPTION
,      SEQUENCE_NUM
,      SOURCE_DOC_HEADER_ID
,      SOURCE_DOC_NUM
,      SOURCE_DOC_TYPE_CODE
,      SOURCE_DOC_TYPE
,      SOURCE_DOC_CURRENCY
,      SOURCE_DOC_RATE
,      SOURCE_DOC_RATE_TYPE
,      SOURCE_DOC_RATE_TYPE_DSP
,      SOURCE_DOC_RATE_DATE
,      SOURCE_DOC_FUNCTIONAL_CURRENCY
,      SOURCE_DOC_LINE_ID
,      SOURCE_DOC_LINE_NUM
,      SOURCE_DOC_CURRENCY_PRICE
,      SOURCE_DOC_BASE_PRICE
,      ITEM_ID
,      ITEM_DESCRIPTION
,      PRICE
,      LINE_TYPE_ID
,      LINE_TYPE
,      ITEM_REVISION
,      CATEGORY_ID
,      UOM
,      TEMPLATE_LINE_PRICE
,      SUGGESTED_SOURCE_ID
,      SOURCE_NAME
,      SUGGESTED_VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      SUGGESTED_VENDOR_CONTACT_ID
,      VENDOR_CONTACT_NAME
,      SUGGESTED_VENDOR_PRODUCT_CODE
,      SUGGESTED_BUYER_ID
,      BUYER_NAME
,      RFQ_REQUIRED_FLAG
,      SOURCE_TYPE_CODE
,      OUTSIDE_OPERATION_FLAG
,      ORDER_TYPE_LOOKUP_CODE
,      ORDER_TYPE_LOOKUP_DSP
,      ITEM_NUMBER
,      ORGANIZATION_ID
,      SUPPLIER_URL
,      SUPPLIER_ITEM_URL
,      ITEM_URL
FROM APPS.ICX_PO_REQ_TEMPLATE_ITEMS_V;

Dependencies

[top of page]

APPS.ICX_PO_REQ_TEMPLATE_ITEMS_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMETERS; FND_GLOBAL - show dependent code; 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_SYSTEM_ITEMS_KFV; PER_PEOPLE_F; PO_DOCUMENT_TYPES; PO_HEADERS; PO_LINES; PO_LINE_TYPES; PO_LOOKUP_CODES; PO_REQEXPRESS_HEADERS; PO_REQEXPRESS_LINES; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES

APPS.ICX_PO_REQ_TEMPLATE_ITEMS_V is not referenced by any database object