DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB dependencies on CSI_COUNTERS_B

Line 3808: csi_counters_b ccb,

3804: From
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

Line 3829: csi_counters_b ccb,

3825: OKC_K_HEADERS_ALL_B hdr,
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'

Line 4035: csi_counters_b ccb,

4031: CV.VALUE_TIMESTAMP timestamp
4032: FROM MTL_SYSTEM_ITEMS_B_KFV sys,
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

Line 4066: csi_counters_b ccb,

4062: CV.NET_READING netreading ,
4063: CV.VALUE_TIMESTAMP timestamp
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,