DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on CSI_COUNTER_ASSOCIATIONS

Line 3809: csi_counter_associations cca

3805: MTL_SYSTEM_ITEMS_B_KFV sys,
3806: CSI_ITEM_INSTANCES cp,
3807: CS_CSI_COUNTER_GROUPS CCG,
3808: csi_counters_b ccb,
3809: csi_counter_associations cca
3810: Where ccb.COUNTER_ID = to_number(p_covered_prod_id)
3811: and sys.INVENTORY_ITEM_ID = cp.INVENTORY_ITEM_ID
3812: and sys.ORGANIZATION_ID = cp.INV_MASTER_ORGANIZATION_ID
3813: AND ccg.template_flag = 'N'

Line 3830: csi_counter_associations cca

3826: OKC_K_ITEMS itm,
3827: OKC_K_LINES_B ln,
3828: CS_CSI_COUNTER_GROUPS CCG,
3829: csi_counters_b ccb,
3830: csi_counter_associations cca
3831: Where
3832: ccb.COUNTER_ID = to_number(p_covered_prod_id)
3833: and ccg.template_flag = 'N'
3834: and ccg.counter_group_id = ccb.group_id

Line 4037: csi_counter_associations cca,

4033: CSI_ITEM_INSTANCES CII,
4034: CS_CSI_COUNTER_GROUPS CCG,
4035: csi_counters_b ccb,
4036: csi_counters_tl cct,
4037: csi_counter_associations cca,
4038: CSI_COUNTER_READINGS CV,
4039: csi_lookups lkup
4040: Where ccb.COUNTER_ID = to_number(p_covered_prod_ID_arg)
4041: and sys.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID

Line 4068: csi_counter_associations cca,

4064: FROM MTL_SYSTEM_ITEMS_B_KFV sys,
4065: CS_CSI_COUNTER_GROUPS CCG,
4066: csi_counters_b ccb,
4067: csi_counters_tl cct,
4068: csi_counter_associations cca,
4069: CSI_COUNTER_READINGS CV,
4070: csi_lookups lkup,
4071: OKC_K_ITEMS KI,
4072: OKC_K_LINES_B KL ,