DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on CSI_COUNTER_READINGS_PVT

Line 4049: AND CV.COUNTER_VALUE_ID (+) = CSI_COUNTER_READINGS_PVT.get_latest_reading(CCB.COUNTER_ID)

4045: AND ccb.counter_id = cca.counter_id
4046: and cca.SOURCE_OBJECT_CODE = 'CP'
4047: and cca.source_object_id = cII.instance_id
4048: and CV.COUNTER_ID (+) = CCB.COUNTER_ID
4049: AND CV.COUNTER_VALUE_ID (+) = CSI_COUNTER_READINGS_PVT.get_latest_reading(CCB.COUNTER_ID)
4050: AND ccb.counter_id = cct.counter_id
4051: AND cct.language = USERENV('LANG')
4052: AND lkup.lookup_type = 'CSI_COUNTER_TYPE'
4053: AND ccb.counter_type = lkup.lookup_code

Line 4082: AND CV.COUNTER_VALUE_ID (+) = CSI_COUNTER_READINGS_PVT.get_latest_reading(CCB.COUNTER_ID)

4078: AND ccb.counter_id = cca.counter_id
4079: and cca.SOURCE_OBJECT_CODE = 'CONTRACT_LINE'
4080: and cca.source_object_id = KL.id
4081: and CV.COUNTER_ID (+) = CCB.COUNTER_ID
4082: AND CV.COUNTER_VALUE_ID (+) = CSI_COUNTER_READINGS_PVT.get_latest_reading(CCB.COUNTER_ID)
4083: AND ccb.counter_id = cct.counter_id
4084: AND cct.language = USERENV('LANG')
4085: AND lkup.lookup_type = 'CSI_COUNTER_TYPE'
4086: AND ccb.counter_type = lkup.lookup_code