SELECT 
    DOCUMENT_ITEMS.ID, 
    DOCUMENT_ITEMS.MARK, 
    DOCUMENT_ITEMS.ID_DOCUMENTS, 
    DOCUMENT_ITEMS.STOCK_ITEMS_NAME, 
    DOCUMENT_ITEMS.ID_STOCKS, 
    DOCUMENT_ITEMS.ID_STOCK_ITEMS_MU, 
    DOCUMENT_ITEMS.UNIT_PRICE, 
    DOCUMENT_ITEMS.AMOUNT, 
    DOCUMENT_ITEMS.SUM, 
    DOCUMENT_ITEMS.STOCK_NAME, 
    DOCUMENT_ITEMS.IS_CONCEPT, 
    DOCUMENT_ITEMS.ORDINAL, 
    DOCUMENT_ITEMS.IS_COMPOSITE, 
    DOCUMENT_ITEMS.ID_COMPOSITE_PARENT, 
    DOCUMENT_ITEMS.ID_VALUE_1, 
    DOCUMENT_ITEMS.ID_VALUE_2, 
    DOCUMENT_ITEMS.ID_VALUE_3, 
    DOCUMENT_ITEMS.ID_VALUE_4, 
    DOCUMENT_ITEMS.ID_VALUE_5, 
    DOCUMENT_ITEMS.ID_VALUE_6, 
    DOCUMENT_ITEMS.DATE_DOCUMENT, 
    DOCUMENT_ITEMS.DATE_MANUFACTURE, 
    DOCUMENT_ITEMS.DATE_EXPIRATION, 
    DOCUMENT_ITEMS.SERIAL_NUMBER, 
    DOCUMENT_ITEMS.PROPERTIES_TEXT, 
    DOCUMENT_ITEMS.BATCH_CODE, 
    DOCUMENT_ITEMS.USER_AMOUNT, 
    DOCUMENT_ITEMS.STOCK_VALUATION_TYPE, 
    DOCUMENT_ITEMS.DESCRIPTION_RTF, 
    DOCUMENT_ITEMS.DESCRIPTION, 
    DOCUMENT_ITEMS.TITLE_ITEM, 
    DOCUMENT_ITEMS.ID_MEASUREUNIT, 
    DOCUMENT_ITEMS.PRICE_ISSUED_STOCK, 
    DOCUMENT_ITEMS.PRICE_MANAGER, 
    DOCUMENT_ITEMS.DATE_EXPIRATION_FOR_BUYER, 
    DOCUMENT_ITEMS.ID_STOCK_ITEMS, 
    DOCUMENT_ITEMS.PRICE_ISSUED_STOCK_SUM, 
    DOCUMENT_ITEMS.PRICE_MANAGER_SUM, 
    DOCUMENT_ITEMS.STOCK_ITEM_TYPE, 
    DOCUMENT_ITEMS.ID_IATREE_1, 
    DOCUMENT_ITEMS.ID_IATREE_2, 
    DOCUMENT_ITEMS.ID_IATREE_3, 
    DOCUMENT_ITEMS.ID_IATREE_4, 
    DOCUMENT_ITEMS.ID_IATREE_5, 
    DOCUMENT_ITEMS.ID_IATREE_6, 
    DOCUMENT_ITEMS.SUM_LC, 
    DOCUMENT_ITEMS.UNIT_PRICE_LC, 
    DOCUMENT_ITEMS.UNIT_PRICE_BASE, 
    DOCUMENT_ITEMS.UNIT_DISCOUNT, 
    DOCUMENT_ITEMS.UNIT_DISCOUNT_PERCENT, 
    DOCUMENT_ITEMS.UNIT_PRICE_BASE_VAT, 
    DOCUMENT_ITEMS.UNIT_DISCOUNT_VAT, 
    DOCUMENT_ITEMS.UNIT_PRICE_VAT, 
    DOCUMENT_ITEMS.SUM_VAT, 
    DOCUMENT_ITEMS.PRICE_LOCKING_FLAGS, 
    DOCUMENT_ITEMS.PRICE_INPUT, 
    DOCUMENT_ITEMS.DISCOUNT_INPUT, 
    DOCUMENT_ITEMS.VAT_RATE, 
    DOCUMENT_ITEMS.VAT_RATE_VALUE, 
    DOCUMENT_ITEMS.UNIT_PRICE_ROUNDING_TYPE, 
    DOCUMENT_ITEMS.UNIT_PRICE_ROUNDING_NUMBER, 
    DOCUMENT_ITEMS.SUM_ROUNDING_TYPE, 
    DOCUMENT_ITEMS.SUM_ROUNDING_NUMBER, 
    DOCUMENT_ITEMS.ID_COMP_ALT, 
    DOCUMENT_ITEMS.TREE_LEVEL, 
    DOCUMENT_ITEMS.AMOUNT_UNIT, 
    DOCUMENT_ITEMS.COMP_CAN_CHANGE_AMOUNT, 
    DOCUMENT_ITEMS.SUM_VAT_LC, 
    DOCUMENT_ITEMS.UNIT_PRICE_VAT_LC, 
    DOCUMENT_ITEMS.UNIT_PRICE_BASE_LC, 
    DOCUMENT_ITEMS.UNIT_PRICE_BASE_VAT_LC, 
    DOCUMENT_ITEMS.COMP_AMOUNT, 
    DOCUMENT_ITEMS.STOCK_ITEMS_MU_COEFFICIENT, 
    DOCUMENT_ITEMS.ID_LINKED_ITEM, 
    DOCUMENT_ITEMS.ID_COVER_PARENT, 
    DOCUMENT_ITEMS.ID_COVER_MU, 
    DOCUMENT_ITEMS.COVER_IS_COMPULSORY, 
    DOCUMENT_ITEMS.DOC_DISCOUNT_LC, 
    DOCUMENT_ITEMS.DATE_RESERVATION, 
    DOCUMENT_ITEMS.ID_MEASUREUNIT_DEFAULT, 
    DOCUMENT_ITEMS.UNIT_DISCOUNT_LC, 
    DOCUMENT_ITEMS.UNIT_DISCOUNT_VAT_LC, 
    DOCUMENT_ITEMS.RESERVATED_AMOUNT, 
    DOCUMENT_ITEMS.RESERVATION_LOCKING_FLAG, 
    DOCUMENT_ITEMS.UNIT_PRICE_MAIN_LC, 
    DOCUMENT_ITEMS.DOC_DISCOUNT_VAT_LC, 
    DOCUMENT_ITEMS.ID_MASTER, 
    DOCUMENT_ITEMS.UNIT_PRICE_STOCK, 
    DOCUMENT_ITEMS.STOCK_ITEM_CODE, 
    DOCUMENT_ITEMS.ACCOUNT_MD_SYN, 
    DOCUMENT_ITEMS.ACCOUNT_MD_ANL, 
    DOCUMENT_ITEMS.ACCOUNT_DAL_SYN, 
    DOCUMENT_ITEMS.ACCOUNT_DAL_ANL, 
    DOCUMENT_ITEMS.ID_ACCOUNT_CODING, 
    DOCUMENT_ITEMS.IST_CODE, 
    DOCUMENT_ITEMS.IST_WEIGHT, 
    DOCUMENT_ITEMS.IST_DMJ, 
    DOCUMENT_ITEMS.IST_COUNTRY, 
    DOCUMENT_ITEMS.IST_DESCRIPTION, 
    DOCUMENT_ITEMS.PRICE_MANAGER_LOCKING_FLAGS, 
    DOCUMENT_ITEMS.DEDUCTED_INVOICES, 
    DOCUMENT_ITEMS.DEDUCTED_VAT, 
    DOCUMENT_ITEMS.PRICE_MAN_SUR, 
    DOCUMENT_ITEMS.PV_ACCEPT, 
    DOCUMENT_ITEMS.ITEM_NAME, 
    DOCUMENT_ITEMS.ACCOUNTING_BALANCE, 
    DOCUMENT_ITEMS.REAL_ACCOUNTING_BALANCE, 
    DOCUMENT_ITEMS.ID_SOURCE_DOCUMENT, 
    DOCUMENT_ITEMS.ID_VALUE_TRANSFER_1, 
    DOCUMENT_ITEMS.ID_VALUE_TRANSFER_2, 
    DOCUMENT_ITEMS.ID_VALUE_TRANSFER_3, 
    DOCUMENT_ITEMS.ID_VALUE_TRANSFER_4, 
    DOCUMENT_ITEMS.ID_VALUE_TRANSFER_5, 
    DOCUMENT_ITEMS.ID_VALUE_TRANSFER_6, 
    DOCUMENT_ITEMS.PROPERTIES_TEXT_TRANSFER, 
    DOCUMENT_ITEMS.ID_COMPOSITE_MAIN_PARENT, 
    DOCUMENT_ITEMS.DOCUMENTATION_AVAL, 
    DOCUMENT_ITEMS.IS_RETURNABLE_COVER
FROM
     DOCUMENT_ITEMS
WHERE
    DOCUMENT_ITEMS.ID_DOCUMENTS IN (117)
ORDER BY
    DOCUMENT_ITEMS.ORDINAL ASC


