EXPLAIN PLAN FOR
SELECT
  so.TRANSACTIONDATE,
  so.INVOICECODE,
  so.COMPANYCODE,
  so.DECOSUBCODE01,
  so.DECOSUBCODE02,
  so.DECOSUBCODE03,
  so.DECOSUBCODE04,
  so.DECOSUBCODE05,
  so.DECOSUBCODE06,
  so.DECOSUBCODE07,
  so.DECOSUBCODE08,
  so.DECOSUBCODE09,
  so.DECOSUBCODE10,
  so.USERPRIMARYUOMCODE,
  so.INTERNALDOCUMENTNUMBER,
  so.QUALITYLEVELCODE,
  so.EXCHANGERATE,
  so.BASEPRIMARYQUANTITY,
  so.USERPRIMARYQUANTITY,
  so.USERPRIMARYUOMCODE,
  so.ABSUNIQUEID,
  LOT.FIRSTENTRYBILLNUMBER,
  LOT.SUPPLIERCODE,


  UNITOFMEASURE.ABSUNIQUEID                    UOMABSUNIQUEID,
  UNITOFMEASURE.LONGDESCRIPTION                UOMLONGDESC,
  UNITOFMEASURE.SEARCHDESCRIPTION              UOMSEARCHDESC,

  STBP.LEGALNAME1                              STBPLEGALNAME1,
  STBP.LEGALNAME2                              STBPLEGALNAME2,

  ORDERPARTNER.CUSTOMERSUPPLIERCODE            OPCUSTOMERSUPPLIERCODE,

  COMPANY.ABSUNIQUEID                          CMPABSUNIQUEID,
  COMPANY.LONGDESCRIPTION                      CMPLONGDESC,

  FULLITEMKEYDECODER.ABSUNIQUEID               FIKDABSUNIQUEID,
  FULLITEMKEYDECODER.SEARCHDESCRIPTION         FIKDSEARCHDESC,

  PURCHASEORDERLINE.PRICE                      POPRICE,
  PURCHASEORDERLINE.ENTRYEXCHANGERATE          POENTRYEXCHANGERATE,
  PURCHASEORDERLINE.ENTRYEXCHANGERATE          PONETVALUEINCLUDINGTAX,
  PURCHASEORDERLINE.ENTRYEXCHANGERATE          POBASEPRIMARYQUANTITY,

  LOTPURCHASELINE.PRICE                        LOTPOPRICE,
  LOTPURCHASELINE.ENTRYEXCHANGERATE            LOTPOENTRYEXCHANGERATE,
  LOTPURCHASELINE.ENTRYEXCHANGERATE            LOTPONETVALUEINCLUDINGTAX,
  LOTPURCHASELINE.ENTRYEXCHANGERATE            LOTPOBASEPRIMARYQUANTITY,

  LOTBP.LEGALNAME1                             LOTBPLEGALNAME1,
  LOTBP.LEGALNAME2                             LOTBPLEGALNAME2,
  ----
  entrypositon.VALUESTRING                  AS entrypositon,
  entrypositonName.VALUESTRING              AS entrypositonName,
  entryLogWHSruDESCRIPTIONS.LONGDESCRIPTION AS entryLogWHSruDESCRIPTIONS,
  ADSTORAGE.VALUESTRING                     AS Article1C_Val
FROM
  (SELECT *
   FROM STOCKTRANSACTION
   WHERE
     --   -- in production
     --         COMPANYCODE = {?ABSUSERPROMPT_CompanyCode} AND
     --         InternalDocumentDate = {?ABSUSERPROMPT_InternalDocumentDate} AND
     --         InternalDocumentNumber = {?ABSUSERPROMPT_InternalDocumentNumber}
     --   -- for test
     CompanyCode = '001' AND
     InternalDocumentDate = TO_DATE('09.02.2017', 'DD.MM.YYYY') AND
     InternalDocumentNumber = '8181'
    --   --
  ) so
  LEFT JOIN (
              SELECT
                LOGICALWAREHOUSECODE,
                LOGICALWAREHOUSECOMPANYCODE
              FROM STOCKTRANSACTION
              WHERE
                --   -- in production
                --                          COMPANYCODE = {?ABSUSERPROMPT_CompanyCode} AND
                --                          InternalDocumentDate = {?ABSUSERPROMPT_InternalDocumentDate} AND
                --                          InternalDocumentNumber = {?ABSUSERPROMPT_InternalDocumentNumber} AND
                --   -- for test
                CompanyCode = '001' AND
                InternalDocumentDate = TO_DATE('09.02.2017', 'DD.MM.YYYY') AND
                InternalDocumentNumber = '8181' AND
                --   --
                STOCKTRANSACTION.ONHANDUPDATE = '1' AND
                ROWNUM = 1
            ) soEntry ON 1 = 1


  LEFT JOIN FULLITEMKEYDECODER ON
                                 so.FULLITEMIDENTIFIER = FULLITEMKEYDECODER.IDENTIFIER
  LEFT JOIN UNITOFMEASURE ON
                            so.USERPRIMARYUOMCODE = UNITOFMEASURE.CODE
  LEFT JOIN PURCHASEORDERLINE ON
                                --PRIMARY KEY (PURCHASEORDERCOMPANYCODE, PURCHASEORDERCOUNTERCODE, PURCHASEORDERCODE, ORDERLINE, ORDERSUBLINE, UUID, LOGTIMESTAMP)
                                so.COMPANYCODE = PURCHASEORDERLINE.PURCHASEORDERCOMPANYCODE AND
                                so.ORDERCOUNTERCODE = PURCHASEORDERLINE.PURCHASEORDERCOUNTERCODE AND
                                so.ORDERCODE = PURCHASEORDERLINE.PURCHASEORDERCODE AND
                                so.ORDERLINE = PURCHASEORDERLINE.ORDERLINE AND
                                so.ORDERSUBLINE = PURCHASEORDERLINE.ORDERSUBLINE
  LEFT JOIN COMPANY ON
                      so.COMPANYCODE = COMPANY.CODE
  LEFT JOIN LOT ON
                  so.COMPANYCODE = LOT.COMPANYCODE AND
                  so.ITEMTYPECODE = LOT.ITEMTYPECODE AND
                  so.DECOSUBCODE01 = LOT.DECOSUBCODE01 AND
                  so.DECOSUBCODE02 = LOT.DECOSUBCODE02 AND
                  so.DECOSUBCODE03 = LOT.DECOSUBCODE03 AND
                  so.DECOSUBCODE04 = LOT.DECOSUBCODE04 AND
                  so.DECOSUBCODE05 = LOT.DECOSUBCODE05 AND
                  so.DECOSUBCODE06 = LOT.DECOSUBCODE06 AND
                  so.DECOSUBCODE07 = LOT.DECOSUBCODE07 AND
                  so.DECOSUBCODE08 = LOT.DECOSUBCODE08 AND
                  so.DECOSUBCODE09 = LOT.DECOSUBCODE09 AND
                  so.DECOSUBCODE10 = LOT.DECOSUBCODE10 AND
                  so.LOTCODE = LOT.CODE
  LEFT JOIN ORDERPARTNER ON
                           --PRIMARY KEY (CUSTOMERSUPPLIERCOMPANYCODE, CUSTOMERSUPPLIERTYPE, CUSTOMERSUPPLIERCODE)
                           so.COMPANYCODE = ORDERPARTNER.CUSTOMERSUPPLIERCOMPANYCODE AND
                           so.SUPPLIERTYPE = ORDERPARTNER.CUSTOMERSUPPLIERTYPE AND
                           so.SUPPLIERCODE = ORDERPARTNER.CUSTOMERSUPPLIERCODE
  LEFT JOIN BUSINESSPARTNER STBP ON
                                   ORDERPARTNER.ORDERBUSINESSPARTNERNUMBERID = STBP.NUMBERID
  LEFT JOIN ORDERPARTNER LOTOP ON
                                 LOT.SUPPLIERCOMPANYCODE = LOTOP.CUSTOMERSUPPLIERCOMPANYCODE AND
                                 LOT.SUPPLIERTYPE = LOTOP.CUSTOMERSUPPLIERTYPE AND
                                 LOT.SUPPLIERCODE = LOTOP.CUSTOMERSUPPLIERCODE
  LEFT JOIN BUSINESSPARTNER LOTBP ON
                                    LOTOP.ORDERBUSINESSPARTNERNUMBERID = LOTBP.NUMBERID
  LEFT JOIN ADSTORAGE LOTAD1 ON
                               --ADSTORAGE PRIMARY KEY (UNIQUEID, NAMEENTITYNAME, NAMENAME, FIELDNAME)
                               LOT.ABSUNIQUEID = LOTAD1.UNIQUEID AND
                               LOTAD1.NAMEENTITYNAME = 'Lot' AND
                               LOTAD1.NAMENAME = 'OrderLine' AND
                               LOTAD1.FIELDNAME = 'OrderLine'
  LEFT JOIN ADSTORAGE LOTAD2 ON
                               LOT.ABSUNIQUEID = LOTAD2.UNIQUEID AND
                               LOTAD2.NAMEENTITYNAME = 'Lot' AND
                               LOTAD2.NAMENAME = 'OrderSubLine' AND
                               LOTAD2.FIELDNAME = 'OrderSubLine'
  LEFT JOIN PURCHASEORDERLINE LOTPURCHASELINE ON
                                                --PRIMARY KEY (PURCHASEORDERCOMPANYCODE, PURCHASEORDERCOUNTERCODE, PURCHASEORDERCODE, ORDERLINE, ORDERSUBLINE, UUID, LOGTIMESTAMP)
                                                LOT.OWNINGCOMPANYCODE = LOTPURCHASELINE.PURCHASEORDERCOMPANYCODE AND
                                                LOT.LOTCREATIONORDERNUMBER = LOTPURCHASELINE.PURCHASEORDERCOUNTERCODE AND
                                                LOT.LOTCREATIONORDERCOUNTER = LOTPURCHASELINE.PURCHASEORDERCODE AND

                                                LOTAD1.VALUEDECIMAL = LOTPURCHASELINE.ORDERLINE AND
                                                LOTAD2.VALUEDECIMAL = LOTPURCHASELINE.ORDERSUBLINE
  LEFT JOIN DIVISION
  --PRIMARY KEY (COMPANYCODE, CODE),
    ON so.COMPANYCODE = DIVISION.COMPANYCODE
  LEFT JOIN ADSTORAGE
    ON
      --ADSTORAGE PRIMARY KEY (UNIQUEID, NAMEENTITYNAME, NAMENAME, FIELDNAME)

      ADSTORAGE.UNIQUEID = FULLITEMKEYDECODER.ABSUNIQUEID AND
      LOTAD1.NAMEENTITYNAME = 'FullItemKeyDecoder' AND (
        (so.QUALITYLEVELCODE = 1 OR so.QUALITYLEVELCODE = 0) AND adstorage.namename = 'Article1C' AND adstorage.FIELDNAME = 'Article1C' OR
        so.QUALITYLEVELCODE = 2 AND adstorage.namename = 'Article1Cq2' AND adstorage.FIELDNAME = 'Article1Cq2' OR
        so.QUALITYLEVELCODE = 3 AND adstorage.namename = 'Article1Cq3' AND adstorage.FIELDNAME = 'Article1Cq3'
      )


  --     SELECT
  --                LanguageDescriptions.LONGDESCRIPTION,
  --                entrypositon.VALUESTRING     AS entrypositon,
  --                entrypositonName.VALUESTRING AS entrypositonName


  LEFT JOIN LOGICALWAREHOUSE entryLogWHS ON soEntry.LOGICALWAREHOUSECODE = entryLogWHS.CODE AND
                                            soEntry.LOGICALWAREHOUSECOMPANYCODE = entryLogWHS.COMPANYCODE

  LEFT JOIN ADSTORAGE entrypositon ON
                                     entrypositon.UNIQUEID = entryLogWHS.ABSUNIQUEID AND
                                     entrypositon.NameEntityName = 'LogicalWarehouse' AND
                                     entrypositon.namename = 'PositionResponsible' AND
                                     entrypositon.fieldname = 'PositionResponsible'
  LEFT JOIN ADSTORAGE entrypositonName ON
                                         entrypositonName.UNIQUEID = entryLogWHS.ABSUNIQUEID AND
                                         entrypositonName.NameEntityName = 'LogicalWarehouse' AND
                                         entrypositonName.namename = 'Responsible' AND
                                         ENTRYPOSITONnAME.FIELDNAME = 'Responsible'


  LEFT JOIN LANGUAGEDESCRIPTIONS entryLogWHSruDESCRIPTIONS ON
                                                             entryLogWHSruDESCRIPTIONS.LANGUAGECODE = 'RU' AND
                                                             entryLogWHSruDESCRIPTIONS.FATHERID = entryLogWHS.ABSUNIQUEID;

SELECT *
FROM
  TABLE (DBMS_XPLAN.DISPLAY);