Query for Requisition total Amount including Tax Amount

Query for Requisition total Amount including Tax Amount, askhareesh blog for Oracle Apps
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;  



2 comments:

  1. E556E1D9D5
    Many businesses are now exploring innovative methods to enhance their product designs and marketing strategies. One popular technique is utilizing dtf transfer for vibrant and durable prints on various materials. This method offers a cost-effective way to produce high-quality images that stand out. By incorporating such advanced printing solutions, companies can better meet customer expectations and stay competitive in the market.

    ReplyDelete