DBA Data[Home] [Help]

APPS.AHL_FMP_COMMON_PVT dependencies on CSI_COUNTER_TEMPLATE_VL

Line 701: FROM csi_counter_template_vl C,

697:
698: CURSOR check_alternate_ctr_id(c_counter_id NUMBER, c_relationship_id NUMBER)
699: IS
700: SELECT 'X'
701: FROM csi_counter_template_vl C,
702: --CS_COUNTER_GROUPS CG,
703: CS_CSI_COUNTER_GROUPS CG,
704: CS_CTR_ASSOCIATIONS CA,
705: AHL_POSITION_ALTERNATES_V PA

Line 735: CSI_COUNTER_TEMPLATE_VL C,

731: SELECT DISTINCT
732: C.COUNTER_ID,
733: C.DEFAULTED_GROUP_ID COUNTER_GROUP_ID
734: FROM
735: CSI_COUNTER_TEMPLATE_VL C,
736: --CS_COUNTER_GROUPS CG
737: --Priyan
738: --Perf changes . Refer Bug # 4913671
739: CS_CSI_COUNTER_GROUPS CG

Line 767: CSI_COUNTER_TEMPLATE_VL C,

763: SELECT DISTINCT
764: C.COUNTER_ID,
765: C.DEFAULTED_GROUP_ID COUNTER_GROUP_ID
766: FROM
767: CSI_COUNTER_TEMPLATE_VL C,
768: --CS_COUNTER_GROUPS CG
769: --Priyan
770: --Perf changes . Refer Bug # 4913671
771: CS_CSI_COUNTER_GROUPS CG

Line 782: csi_counter_template_vl C,

778: CURSOR validate_item_ctr_id(c_counter_id NUMBER, c_inventory_item_id NUMBER)
779: IS
780: SELECT 'X'
781: FROM --cs_counters c,
782: csi_counter_template_vl C,
783: --cs_counter_groups CG,
784: CS_CSI_COUNTER_GROUPS CG,
785: cs_ctr_associations CA
786: where --C.counter_group_id = CG.counter_group_id