Vic's queries:
UCFA_QA_CALLABLE_SQL_CHUNKS (Checks to see if your Callable SQL is chunking correctly. If you are missing any of your SQL, then it's not.)
SELECT DISTINCT A.EQTN_OPERAND_SQL, TO_CHAR(A.EFFDT,'YYYY-MM-DD'), A.EQTN_SQL_CHUNK_SEQ, A.EQTN_SQL_CHUNK, A.SCC_DATA_TYPE_CD
FROM PS_EQTN_SQL_CHUNKS A
WHERE ( A.EFFDT =
(SELECT MAX(A_ED.EFFDT) FROM PS_EQTN_SQL_CHUNKS A_ED
WHERE A.EQTN_OPERAND_SQL = A_ED.EQTN_OPERAND_SQL
AND A_ED.EFFDT <= SYSDATE)
AND A.EQTN_OPERAND_SQL = :1)
ORDER BY 3
UCFA_RPT_XML_EQNDETAIL (Used to export a single Equation and Callable SQL to Excel.)
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
This 2nd one has 2 expressions:
