View: POR_VIEW_DIST_HEADER_V

Product:	ICX - Oracle iProcurement
Description:	This view is obsolete.
Implementation/DBA Data:	APPS.POR_VIEW_DIST_HEADER_V

View Text

SELECT PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, MSI.SEGMENT1
, MC.CONCATENATED_SEGMENTS
, PRL.ITEM_DESCRIPTION
, PRL.UNIT_PRICE
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.QUANTITY
, PRL.UNIT_PRICE
, PRL.UNIT_PRICE
, TO_CHAR(PRL.UNIT_PRICE * (PRL.QUANTITY - NVL(PRL.QUANTITY_CANCELLED
, 0))
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SOB.CURRENCY_CODE
, 30))
, PRL.LINE_TYPE_ID
, PRL.CATALOG_TYPE
FROM PO_REQUISITION_LINES PRL
, MTL_SYSTEM_ITEMS MSI
, MTL_CATEGORIES_KFV MC
, GL_SETS_OF_BOOKS SOB
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE PRL.CATEGORY_ID = MC.CATEGORY_ID
AND PRL.ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND PRL.DESTINATION_ORGANIZATION_ID = MSI.ORGANIZATION_ID(+)
AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID

Columns