VIEW: APPS.POR_VIEW_DIST_HEADER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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