SELECT prla.line_num line_number, prla.item_description line_description, prda.distribution_num dist_number, prda.code_combination_id dist_code_combination_id, NVL (prda.nonrecoverable_tax, 0) nonrecoverable_tax, NVL (prda.recoverable_tax, 0) recoverable_tax, NVL (prda.nonrecoverable_tax, 0) + NVL (prda.recoverable_tax, 0) total_tax, (NVL (prda.req_line_quantity, 0) * NVL (prla.unit_price, 0)) amount, prda.org_id, prda.DISTRIBUTION_ID FROM po_requisition_lines_all prla, po_req_distributions_all prda WHERE prla.requisition_line_id = prda.requisition_line_id AND NVL (prla.cancel_flag, 'N') <> 'Y' AND NVL (prla.modified_by_agent_flag, 'N') = 'N' -- AND prla.requisition_header_id = :1 ORDER BY prla.line_num, prda.distribution_num;
No comments:
Post a Comment