View: POR_VIEW_DIST_LINES_V

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

View Text

SELECT PRD.REQUISITION_LINE_ID
, PRD.DISTRIBUTION_NUM
, CC.CONCATENATED_SEGMENTS
, (PRD.REQ_LINE_QUANTITY * 100)/PRL.QUANTITY
, PRD.REQ_LINE_QUANTITY
, TO_CHAR((PRD.REQ_LINE_QUANTITY * PRL.UNIT_PRICE)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SOB.CURRENCY_CODE
, 30))
FROM PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS PRD
, GL_CODE_COMBINATIONS_KFV CC
, GL_SETS_OF_BOOKS SOB
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND CC.CODE_COMBINATION_ID = PRD.CODE_COMBINATION_ID
AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID

Columns