Requisition Details Query
select -----------------Requisition Header Information hou.name req_bu, porh.REQUISITION_NUMBER, to_char(PORH.CREATION_DATE,'DD/MM/YYYY','NLS_DATE_LANGUAGE =AMERICAN') PR_DT, PPNF.DISPLAY_NAME ENTER_BY, porh.DESCRIPTION req_desc, --PORH.DOCUMENT_STATUS req_status, req_appr_status.MEANING req_status, PORH.JUSTIFICATION, to_char(PORH.APPROVED_DATE,'DD/MM/YYYY','NLS_DATE_LANGUAGE =AMERICAN') APPROVED_DATE, (CASE WHEN PORD.DISTRIBUTION_QUANTITY IS NULL THEN (NVL(PORD.NONRECOVERABLE_TAX,0)*NVL(PORL.RATE,0)+NVL(PORD.DISTRIBUTION_CURRENCY_AMOUNT,0)) ELSE (PORD.DISTRIBUTION_QUANTITY* NVL(PORL.CURRENCY_UNIT_PRICE,0)+NVL(PORD.NONRECOVERABLE_TAX,0)*NVL(PORL.RATE,0)) end ) req_amount, (CASE WHEN PORD.DISTRIBUTION_QUANTITY IS NULL THEN NVL(PORD.DISTRIBUTION_CURRENCY_AMOUNT,0) ELSE (PORD.DISTRIBUTION_QUANTITY* NVL(PORL.CURRENCY_UNIT_PRICE,0)) end ) approval_amount, null has_attachment, -----------------------...