[Home] [Help]
View: POR_PUBLIC_LIST_ITEMS_V
| Product: | ICX - Oracle iProcurement |
|---|
| Description: | Public shopping list items view |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT POR_PO_HEADER_ID
, POR_PO_LINE_ID
, POR_SOURCE_DOC_LINE_NUM
, POR_LINE_TYPE
, POR_ITEM_ID
, POR_ITEM_REVISION
, POR_SUPPL_SITE
, POR_SUPPL_CONTACT
, POR_ITEM_DESCRIPTION
, POR_UNIT_OF_MEASURE
, POR_UNIT_PRICE
, POR_CATEGORY
, POR_CATEGORY_ID
, POR_SUPPL_NAME
, POR_LINE_TYPE_ID
, POR_ITEM_NUM
, POR_SUPPL_ITEM_NUM
, POR_SUPPL_CONTACT_PHONE
, ROWNUM
, POR_BUYER_NAME
, POR_AGENT_ID
, POR_TEMPLATE_NAME
, POR_ITEM_PURCHASABLE_FLAG
, POR_INTERNAL_ORDERABLE_FLAG
, POR_SUPPLIER_ID
, POR_SUPPLIER_SITE_ID
FROM ICX_POR_SEARCH_TEMPLATES_V
Columns
| Name |
| POR_PO_HEADER_ID |
| POR_PO_LINE_ID |
| POR_SOURCE_DOC_LINE_NUM |
| POR_LINE_TYPE |
| POR_ITEM_ID |
| POR_ITEM_REVISION |
| POR_SUPPL_SITE |
| POR_SUPPL_CONTACT |
| POR_ITEM_DESCRIPTION |
| POR_UNIT_OF_MEASURE |
| POR_UNIT_PRICE |
| POR_CATEGORY |
| POR_CATEGORY_ID |
| POR_SUPPL_NAME |
| POR_LINE_TYPE_ID |
| POR_ITEM_NUM |
| POR_SUPPL_ITEM_NUM |
| POR_SUPPL_CONTACT_PHONE |
| POR_ROWNUM |
| POR_BUYER_NAME |
| POR_AGENT_ID |
| POR_TEMPLATE_NAME |
| POR_ITEM_PURCHASABLE_FLAG |
| POR_INTERNAL_ORDERABLE_FLAG |
| POR_SUPPLIER_ID |
| POR_SUPPLIER_SITE_ID |