148: SRV.SERVICE_INVENTORY_ITEM_ID INVENTORY_ITEM_ID
149: FROM
150: CS_CONTRACTS CON,
151: CS_CP_SERVICES SRV,
152: CS_CONTRACT_STATUSES STS
153: WHERE
154: CON.CONTRACT_ID = SRV.CONTRACT_ID AND
155: CON.CONTRACT_NUMBER =
156: NVL(p_contract_number,CON.CONTRACT_NUMBER) AND
188: CS_CP_SERVICES SRV,
189: CS_CUSTOMER_PRODUCTS PROD,
190: CS_CONTRACT_COVERAGE_LEVELS COVL,
191: CS_COVERED_PRODUCTS COVP,
192: CS_CONTRACT_STATUSES STS
193: WHERE
194: CON.CONTRACT_ID = SRV.CONTRACT_ID AND
195: STS.ELIGIBLE_FOR_INVOICING = 'Y' AND
196: (