有PO没PR的查询

SELECT RRSL.Rcv_Transaction_Id,
                 --pre.attribute1,
                     (case
                       when p_acct = '16049901' then
                        (select TRIM(fa.SERIAL_NUMBER)
                           from FA_ADDITIONS_V fa
                          where fa.ASSET_NUMBER = PR.attribute1
                            and rownum = 1)
                      when p_acct = '16049902' then
                        (select TRIM(fa.SERIAL_NUMBER)
                           from FA_ADDITIONS_V fa
                          where fa.ASSET_NUMBER = PR.attribute1
                            and rownum = 1)
                       else
                        PR.attribute1
                     end) segment1,
                     '' item_number,
                     -- Rrs.Je_Source_Name
                     '采购接收' SOURCES, --来源
                     1 seq,
                     'TOT' seq_TT,
                     RSH.RECEIPT_NUM num,--接收单号
                     RRSL.accounting_date DATES, --日期
                     (Nvl((RRSL.Accounted_dr), 0) -
                     Nvl((RRSL.Accounted_cr), 0)) Amt --本位币金额
                from (SELECT PRL.ATTRIBUTE1,
                             PRH.REQUISITION_HEADER_ID,
                             PRL.REQUISITION_LINE_ID,
                             PRL.LINE_LOCATION_ID,
                             PRD.DISTRIBUTION_ID
                        FROM PO_REQUISITION_HEADERS_ALL PRH, 
                             PO_REQUISITION_LINES_ALL PRL,
                             PO_REQ_DISTRIBUTIONS_ALL PRD
                       WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
                         AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID) PR,--退货没有PR 因此作为子查询
                     Po_Headers_All             POH,
                     po_lines_all               POL,
                     po_line_locations_all      PLL, --  PRE PO RSL RSH RT
                     po_distributions_all       PDA,
                     RCV_TRANSACTIONS           RT,
                     Rcv_Receiving_Sub_Ledger   RRSL,
                     gl_code_combinations       gcc,
                     RCV_SHIPMENT_HEADERS       RSH,
                     RCV_SHIPMENT_LINES         RSL
               WHERE 1 = 1
                 and POH.po_header_id = POL.po_header_id
                 AND POL.PO_LINE_ID = PLL.PO_LINE_ID
                 and PLL.line_location_id = PDA.LINE_LOCATION_ID
                 --and PLA.po_line_id = RSL.po_line_id
                 
                 AND PLL.LINE_LOCATION_ID = PR.LINE_LOCATION_ID(+)--用子查询的外连接
                 AND PR.DISTRIBUTION_ID = PDA.REQ_DISTRIBUTION_ID--delete:子查询之后 此条件导致查不出退货（采购订单号）%5038 
                 AND RT.ORGANIZATION_ID = PLL.SHIP_TO_ORGANIZATION_ID
                 AND RT.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
                 
                 --***重要条件**
                 --AND RSL.PO_DISTRIBUTION_ID = PDA.PO_DISTRIBUTION_ID--delete by wrh 20140605:缺少201402的510100009739
                 AND RT.PO_DISTRIBUTION_ID = PDA.PO_DISTRIBUTION_ID
                 --***重要条件**
                 
                 AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
                 AND RT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID(+)
                 AND RT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
                 
                 AND RT.TRANSACTION_ID = RRSL.Rcv_Transaction_Id
                 --AND pre.requisition_line_id = rt.requisition_line_id(+)
                 and RRSL.code_combination_id = gcc.code_combination_id
                 and gcc.segment3 = nvl(p_acct, gcc.segment3)
                 and to_char(RRSL.accounting_date, 'YYYY-MM') =
                     nvl(p_date, to_char(RRSL.accounting_date, 'YYYY-MM'))
                 and POH.org_id = p_org_id