""""SQL queries and params for getting physical reserves. """
SQL_GET_PHYSICAL_RESERVES = """
SELECT
to_char(
    to_date(
        P_TAKEN.MONTH || '/' || P_TAKEN.YEAR, 'MM/YYYY'), 'Mon YYYY'
    ) AS "RESERVE TAKEN",
    to_char(
        to_date(
            P_RELEASED.MONTH || '/' || P_RELEASED.YEAR, 'MM/YYYY'
        ), 'Mon YYYY'
    ) AS "EXPECTED RELEASE",
    C.ISO_4217_CODE AS CURRENCY,
    to_number(M.AMOUNT_IN_ORIGINAL_CURRENCY, 18, 2) AS AMOUNT,
    M.APPLY_TO_PERIOD_ID as PERIOD
FROM
  ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.MANUAL_ADJUSTMENT M
INNER JOIN FACTS.PROD.DIM_PERIOD P_RELEASED
  ON P_RELEASED.PERIODID=M.APPLY_TO_PERIOD_ID
INNER JOIN FACTS.PROD.DIM_PERIOD P_TAKEN
  ON P_TAKEN.PERIODID=M.ADJUST_FOR_PERIOD_ID
INNER JOIN
  ORCHARD_APP_REPORTING_V2.ART_RELATIONS_PROD_ART_RELATIONS.CURRENCIES C
  ON C.ID=M.CURRENCIES_ID
WHERE M.CATEGORY_ID = 69
  AND M.PARENT_ID = :vendor_id
ORDER BY to_number(P_RELEASED.YEAR) ASC, to_number(P_RELEASED.MONTH) ASC;
"""