[Home] [Help]
View: 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
Name |
REQUISITION_LINE_ID |
LINE_NUMBER |
ITEM_NUMBER |
CATEGORY |
DESCRIPTION |
UNIT_PRICE |
UNIT_OF_MEASURE |
QUANTITY |
RATE_PER_UNIT |
SERVICE_COST |
EXTENDED_PRICE |
LINE_TYPE_ID |
CATALOG_TYPE |