DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on CSI_COUNTER_TEMPLATE_VL

Line 690: FROM csi_counter_template_vl C,

686:
687: CURSOR check_alternate_ctr_id(c_counter_id NUMBER, c_relationship_id NUMBER)
688: IS
689: SELECT 'X'
690: FROM csi_counter_template_vl C,
691: --CS_COUNTER_GROUPS CG,
692: CS_CSI_COUNTER_GROUPS CG,
693: CS_CTR_ASSOCIATIONS CA,
694: AHL_POSITION_ALTERNATES_V PA

Line 724: CSI_COUNTER_TEMPLATE_VL C,

720: SELECT DISTINCT
721: C.COUNTER_ID,
722: C.DEFAULTED_GROUP_ID COUNTER_GROUP_ID
723: FROM
724: CSI_COUNTER_TEMPLATE_VL C,
725: --CS_COUNTER_GROUPS CG
726: --Priyan
727: --Perf changes . Refer Bug # 4913671
728: CS_CSI_COUNTER_GROUPS CG

Line 756: CSI_COUNTER_TEMPLATE_VL C,

752: SELECT DISTINCT
753: C.COUNTER_ID,
754: C.DEFAULTED_GROUP_ID COUNTER_GROUP_ID
755: FROM
756: CSI_COUNTER_TEMPLATE_VL C,
757: --CS_COUNTER_GROUPS CG
758: --Priyan
759: --Perf changes . Refer Bug # 4913671
760: CS_CSI_COUNTER_GROUPS CG

Line 771: csi_counter_template_vl C,

767: CURSOR validate_item_ctr_id(c_counter_id NUMBER, c_inventory_item_id NUMBER)
768: IS
769: SELECT 'X'
770: FROM --cs_counters c,
771: csi_counter_template_vl C,
772: --cs_counter_groups CG,
773: CS_CSI_COUNTER_GROUPS CG,
774: cs_ctr_associations CA
775: where --C.counter_group_id = CG.counter_group_id