Another thing Vic Goldberg gave me. He built a BI Publisher report so if you want that, you might have to reach out to him. But, I just run the query and dump it to Excel. It's an easy way to share code with others or to document your processes (I'm currently working on this task).
SELECT A.EQUATION_NAME, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.DESCR, B.EQTN_ROW_SEQ/10, B.EQUATION_KEYWORD, B.EQTN_OPERAND_TYPE, Case
when B.EQTN_OPERAND_TYPE = 'N' then
to_char( B.EQTN_OPERAND_NUM)
else
trim(concat( B.EQTN_OPERAND_STR,
concat( TO_CHAR(B.EQTN_OPERAND_DT,'YYYY-MM-DD'),
concat( B.RECNAME,
concat( B.FIELDNAME,
concat( B.EQTN_OPERAND_VAL,
concat( B.EQTN_OPERAND_EQTN,
concat( B.EQTN_OPERAND_XTRN,
concat( B.EQTN_OPERAND_LOC,
concat( B.EQTN_OPERAND_GLB,
concat( B.EQTN_OPERAND_APPL, B.EQTN_OPERAND_SQL)))))))))))
end, B.EQTN_COMMENT, C.EQTN_SQL_TEXT, TO_CHAR(SYSDATE,'YYYY-MM-DD'), TO_CHAR(SYSDATE,'YYYY-MM-DD')
FROM PS_EQUATION_TBL A, (PS_EQUATION_DTL B LEFT OUTER JOIN PS_EQTN_SQL_TBL C ON C.EQTN_OPERAND_SQL = B.EQTN_OPERAND_SQL AND C.EFFDT =
(SELECT MAX(C_ED.EFFDT) FROM PS_EQTN_SQL_TBL C_ED
WHERE C.EQTN_OPERAND_SQL = C_ED.EQTN_OPERAND_SQL
AND C_ED.EFFDT <= SYSDATE) )
WHERE ( A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_EQUATION_TBL A_ED
WHERE A.EQUATION_NAME = A_ED.EQUATION_NAME
AND A_ED.EFFDT <= SYSDATE)
AND A.EFF_STATUS = 'A'
AND A.EQUATION_NAME = :1
AND B.EQUATION_NAME = A.EQUATION_NAME
AND B.EFFDT =
(SELECT MAX(B_ED.EFFDT) FROM PS_EQUATION_DTL B_ED
WHERE B.EQUATION_NAME = B_ED.EQUATION_NAME
AND B_ED.EFFDT <= SYSDATE))
ORDER BY 1, 4
------------------------------
Dana Pawlowicz
Business Systems Analyst Sr - ERP
University of Cincinnati
------------------------------
Message from the HEUG Marketplace:------------------------------
Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the
HEUG Marketplace.
------------------------------