Skip to Content
0
Sep 10, 2019 at 11:55 AM

Reporting on FCI_ONT_LINE_ITEM_RESP with Master Agreement

83 Views

Hi ,

I'm trying to build a custom query with the output details of Master Agreement Line items and it's specifications. I have the query as below so far...

Can some one help me to bridge a link between table - FCI_CONTRACT_LINEITEM and the Line item specification data created within MA-> Line items? Is the data would be found in FCI_DCOM_ITEM_SPEC ?
SELECT <%RESULTS%> FROM <%SCHEMA%>.FCI_CONTRACT T2 LEFT JOIN <%SCHEMA%>.FCI_CONTRACT_LINEITEM LI ON T2.OBJECTID=LI.PARENT_OBJECT_ID LEFT JOIN <%SCHEMA%>.FCI_MAS_VENDOR VEN ON T2.VENDOR_OBJECT_ID=VEN.OBJECTID

<.....need link to a specific line item specification values in MA- Line items..>

WHERE

T2.INACTIVE = 0 AND

T2.VENDOR_OBJECT_ID=VEN.OBJECTID AND
T2.UNIQUE_DOC_NAME LIKE ? AND
T2.IS_TEMPLATE = 0 AND
T2.CONTEXTID=<%CONTEXT(contracts.Contract)%>

<%ORDERBY%>


Or is there any standard query which uses this data? We are under e-souring CLM 11.0. Thanks, Thomas