eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.POR_VIEW_DIST_LINES_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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