Contract Document - Current Status

[Former Member]

Hi Experts,

I need to create a custom report through query, which should show the columns Master Agreement, Contract Name, Current Phase, and Duration of each phase; so please let me know which <%SCHEMA%> needs to be used to get these information without repetitive records.

Thanks & Regards,

Dev

[former_member207877 · Accepted solution]

Hi Devasarathy,

Below query helps you to get columns Master Agreement, Contract Name, Current Phase.

SELECT <%RESULTS%>

FROM <%SCHEMA%>.FCI_CONTRACT T2 LEFT OUTER JOIN <%SCHEMA%>.FCI_CONGEN_CONTRACT_DOC T3

ON

T2.OBJECTID = T3.PARENT_OBJECT_ID

LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_VALUE_LIST_VALUE T4

ON T2.STATUS_OBJECT_ID= T4.OBJECTID

WHERE T2.INACTIVE=0

Group By (T2.OBJECTID,T2.UNIQUE_DOC_NAME,T4.DISPLAY_NAME)

In result fields you have yo give FCI_GET_COMMA_LIST('SELECT T6.DISPLAY_NAME FROM <%SCHEMA%>.FCI_CONGEN_CONTRACT_DOC T6 WHERE T6.PARENT_OBJECT_ID='||T2.OBJECTID)  for Contract Name  column

for displaying all contract documents in that respective MA.

Regards,

Rajshekhar Reddy.