DBA Data[Home] [Help]

APPS.CSI_COUNTER_TEMPLATE_PUB dependencies on CSI_COUNTER_TEMPLATE_B

Line 4783: FROM csi_ctr_item_associations cia, csi_counter_template_b ctr

4779:
4780: CURSOR ctr_item_assoc(p_source_object_id_template NUMBER) IS
4781: SELECT cia.counter_id, cia.group_id, cia.associated_to_group,
4782: ctr.counter_type, cia.primary_failure_flag
4783: FROM csi_ctr_item_associations cia, csi_counter_template_b ctr
4784: WHERE cia.counter_id = ctr.counter_id
4785: AND inventory_item_id = p_source_object_id_template
4786: AND nvl(cia.associated_to_group,'N') = 'N'
4787: AND nvl (cia.end_date_active, sysdate+1) > sysdate