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 ?
<.....need link to a specific line item specification values in MA- Line items..>
T2.INACTIVE = 0 ANDT2.VENDOR_OBJECT_ID=VEN.OBJECTID AND