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


VIEW: APPS.ICX_PO_SUPPL_SEARCH_ITEMS_V

Object Details
Object Name: ICX_PO_SUPPL_SEARCH_ITEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_PO_SUPPL_SEARCH_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 Comments
CONID NUMBER


SCORE NUMBER


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)

TYPE_NAME VARCHAR2 (80)

DOCUMENT_STATUS_CODE VARCHAR2 (25)

DOCUMENT_STATUS_DSP VARCHAR2 (80)

DOCUMENT_NUM VARCHAR2 (20)

AGENT_ID NUMBER (9)

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


LINE_NUM VARCHAR2 (40)

LINE_TYPE_ID VARCHAR2 (40)

LINE_TYPE VARCHAR2 (25)

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)

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)

ORDER_TYPE_LOOKUP_DSP VARCHAR2 (80)

SUPPLIER_URL VARCHAR2 (150)

SUPPLIER_ITEM_URL VARCHAR2 (240)

ITEM_URL VARCHAR2 (240)

ITEM_NUMBER VARCHAR2 (40)

ORGANIZATION_ID NUMBER


Query Text

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


SELECT CONID
,      SCORE
,      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_SEARCH_ITEMS_V;

Dependencies

[top of page]

APPS.ICX_PO_SUPPL_SEARCH_ITEMS_V references the following:

SchemaAPPS
SynonymAP_TERMS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_GLOBAL - show dependent code
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
SynonymICX_CONTEXT_RESULTS_TEMP
SynonymMTL_CATEGORIES_KFV
SynonymMTL_SYSTEM_ITEMS_KFV
ViewPER_PEOPLE_F
SynonymPO_DOCUMENT_TYPES
SynonymPO_HEADERS
SynonymPO_LINES
SynonymPO_LINE_TYPES
ViewPO_LOOKUP_CODES
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES

APPS.ICX_PO_SUPPL_SEARCH_ITEMS_V is not referenced by any database object