DBA Data[Home] [Help]

APPS.EGO_ICC_STRUCTURE_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_B_KFV

Line 797: from MTL_ITEM_CATALOG_GROUPS_B_KFV

793:
794: if p_parent_bill_seq_id is null then
795: select concatenated_segments
796: into l_item_catalog_grp_name
797: from MTL_ITEM_CATALOG_GROUPS_B_KFV
798: where item_catalog_group_id = p_item_catalog_grp_id;
799: else
800: select pk1_value
801: into l_item_catalog_grp_id

Line 808: from MTL_ITEM_CATALOG_GROUPS_B_KFV

804: and obj_name= 'EGO_CATALOG_GROUP';
805:
806: select concatenated_segments
807: into l_item_catalog_grp_name
808: from MTL_ITEM_CATALOG_GROUPS_B_KFV
809: where item_catalog_group_id = l_item_catalog_grp_id;
810: end if;
811:
812: return l_item_catalog_grp_name;