APPS.CSI_COUNTER_TEMPLATE_PUB dependencies on MTL_SYSTEM_ITEMS_KFV

Line 4812: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE; --Changed for Bug 14256395

4808: l_count NUMBER;
4809: l_return_message VARCHAR2(100);
4810:
4811: l_COMMS_NL_TRACKABLE_FLAG VARCHAR2(1);
4812: l_item MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE; --Changed for Bug 14256395
4813: l_counter_id NUMBER;
4814: l_validation_level NUMBER;
4815: l_source_object_cd VARCHAR2(30);
4816:

Line 4949: FROM mtl_system_items_kfv

4945: SELECT COMMS_NL_TRACKABLE_FLAG,
4946: concatenated_segments
4947: INTO l_COMMS_NL_TRACKABLE_FLAG,
4948: l_item
4949: FROM mtl_system_items_kfv
4950: WHERE inventory_item_id = p_source_object_id_template
4951: AND organization_id = p_organization_id --cs_std.get_item_valdn_orgzn_id
4952: AND (NVL(COMMS_NL_TRACKABLE_FLAG,'N') = 'Y' or NVL(service_item_flag,'N') = 'Y');
4953: EXCEPTION