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_SUPPL_CAT_ITEMS_V

Object Details

Object Name:	ICX_PO_SUPPL_CAT_ITEMS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.ICX_PO_SUPPL_CAT_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	Mandatory
PO_HEADER_ID	VARCHAR2	(40)
VENDOR_ID	NUMBER
VENDOR_NAME	VARCHAR2	(240)
VENDOR_CONTACT_ID	NUMBER
VENDOR_CONTACT_NAME	VARCHAR2	(32)
PARENT_VENDOR_ID	NUMBER
HOLD_FLAG	VARCHAR2	(1)
VENDOR_SITE_ID	NUMBER
VENDOR_SITE_CODE	VARCHAR2	(15)
TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes
TYPE_NAME	VARCHAR2	(80)	Yes
DOCUMENT_STATUS_CODE	VARCHAR2	(25)
DOCUMENT_STATUS_DSP	VARCHAR2	(80)	Yes
DOCUMENT_NUM	VARCHAR2	(20)	Yes
AGENT_ID	NUMBER	(9)	Yes
AGENT_NAME	VARCHAR2	(240)
HEADER_PAYMENT_TERMS_ID	NUMBER
HEADER_PAYMENT_TERMS_NAME	VARCHAR2	(50)
HEADER_SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)
HEADER_FREIGHT_TERMS_CODE	VARCHAR2	(25)
HEADER_FOB_LOOKUP_CODE	VARCHAR2	(25)
CURRENCY_CODE	VARCHAR2	(15)
RATE_TYPE	VARCHAR2	(30)
RATE_DATE	DATE
RATE	NUMBER
VENDOR_QUOTE_NUM	VARCHAR2	(25)
QUOTE_APPROVAL_REQUIRED_FLAG	VARCHAR2	(1)
ASSOCIATED_RFQ_ID	NUMBER
EFFECTIVE_FROM	DATE
EFFECTIVE_TO	DATE
AMOUNT_AGREED	NUMBER
AMOUNT_LIMIT	NUMBER
HEADER_MIN_RELEASE_AMOUNT	NUMBER
PO_LINE_ID	NUMBER		Yes
LINE_NUM	VARCHAR2	(40)
LINE_TYPE_ID	VARCHAR2	(40)
LINE_TYPE	VARCHAR2	(25)	Yes
LINE_SHIP_CONCAT_NUM	VARCHAR2	(40)
ITEM_ID	VARCHAR2	(40)
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	NUMBER
CATEGORY_NAME	VARCHAR2	(163)
ITEM_DESCRIPTION	VARCHAR2	(240)
LINE_UOM	VARCHAR2	(25)
LINE_QUANTITY	NUMBER
CURRENCY_LINE_PRICE	NUMBER
VENDOR_PRODUCT_NUM	VARCHAR2	(25)
QUANTITY_AGREED	NUMBER
QUOTE_MIN_ORDER_QUANTITY	NUMBER
QUOTE_MAX_ORDER_QUANTITY	NUMBER
FUNCTIONAL_CURRENCY	VARCHAR2	(15)	Yes
FUNCTIONAL_LINE_PRICE	NUMBER
FUNCTIONAL_SHIPMENT_PRICE	NUMBER
PRICE	NUMBER
RATE_TYPE_NAME	VARCHAR2	(30)
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes
ORDER_TYPE_LOOKUP_DSP	VARCHAR2	(80)	Yes
SUPPLIER_URL	VARCHAR2	(150)
SUPPLIER_ITEM_URL	VARCHAR2	(240)
ITEM_URL	VARCHAR2	(240)
ITEM_NUMBER	VARCHAR2	(40)
ORGANIZATION_ID	NUMBER		Yes

Query Text

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


SELECT PO_HEADER_ID
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_CONTACT_ID
,      VENDOR_CONTACT_NAME
,      PARENT_VENDOR_ID
,      HOLD_FLAG
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      TYPE_LOOKUP_CODE
,      TYPE_NAME
,      DOCUMENT_STATUS_CODE
,      DOCUMENT_STATUS_DSP
,      DOCUMENT_NUM
,      AGENT_ID
,      AGENT_NAME
,      HEADER_PAYMENT_TERMS_ID
,      HEADER_PAYMENT_TERMS_NAME
,      HEADER_SHIP_VIA_LOOKUP_CODE
,      HEADER_FREIGHT_TERMS_CODE
,      HEADER_FOB_LOOKUP_CODE
,      CURRENCY_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      VENDOR_QUOTE_NUM
,      QUOTE_APPROVAL_REQUIRED_FLAG
,      ASSOCIATED_RFQ_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      AMOUNT_AGREED
,      AMOUNT_LIMIT
,      HEADER_MIN_RELEASE_AMOUNT
,      PO_LINE_ID
,      LINE_NUM
,      LINE_TYPE_ID
,      LINE_TYPE
,      LINE_SHIP_CONCAT_NUM
,      ITEM_ID
,      ITEM_REVISION
,      CATEGORY_ID
,      CATEGORY_NAME
,      ITEM_DESCRIPTION
,      LINE_UOM
,      LINE_QUANTITY
,      CURRENCY_LINE_PRICE
,      VENDOR_PRODUCT_NUM
,      QUANTITY_AGREED
,      QUOTE_MIN_ORDER_QUANTITY
,      QUOTE_MAX_ORDER_QUANTITY
,      FUNCTIONAL_CURRENCY
,      FUNCTIONAL_LINE_PRICE
,      FUNCTIONAL_SHIPMENT_PRICE
,      PRICE
,      RATE_TYPE_NAME
,      OUTSIDE_OPERATION_FLAG
,      ORDER_TYPE_LOOKUP_CODE
,      ORDER_TYPE_LOOKUP_DSP
,      SUPPLIER_URL
,      SUPPLIER_ITEM_URL
,      ITEM_URL
,      ITEM_NUMBER
,      ORGANIZATION_ID
FROM APPS.ICX_PO_SUPPL_CAT_ITEMS_V;

Dependencies

[top of page]

APPS.ICX_PO_SUPPL_CAT_ITEMS_V references the following:

APPS: AP_TERMS; 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_CATEGORIES_KFV; MTL_SYSTEM_ITEMS_KFV; PER_PEOPLE_F; PO_DOCUMENT_TYPES; PO_HEADERS; PO_LINES; PO_LINE_TYPES; PO_LOOKUP_CODES; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES

APPS.ICX_PO_SUPPL_CAT_ITEMS_V is not referenced by any database object