APPS.EGO_PUBLICATION_PKG dependencies on MTL_CATEGORIES_B_KFV

Line 531: FROM MTL_CATEGORIES_B_KFV CAT,

527: 'ATTRIBUTE6',CAT.ATTRIBUTE6,'ATTRIBUTE7',CAT.ATTRIBUTE7,'ATTRIBUTE8',CAT.ATTRIBUTE8,
528: 'ATTRIBUTE9',CAT.ATTRIBUTE9,'ATTRIBUTE10',CAT.ATTRIBUTE10,'ATTRIBUTE11',CAT.ATTRIBUTE11,
529: 'ATTRIBUTE12',CAT.ATTRIBUTE12,'ATTRIBUTE13',CAT.ATTRIBUTE13,'ATTRIBUTE14',CAT.ATTRIBUTE14)))))))
530: INTO x_temp
531: FROM MTL_CATEGORIES_B_KFV CAT,
532: FND_DESCR_FLEX_COL_USAGE_VL FND
533: WHERE (FND.APPLICATION_ID=401)
534: AND (FND.DESCRIPTIVE_FLEXFIELD_NAME LIKE 'MTL_CATEGORIES')
535: AND FND.ENABLED_FLAG ='Y'

Line 552: FROM MTL_CATEGORIES_B_KFV CAT

548: XMLELEMENT("ID",catId))),
549: XMLELEMENT("Classification",
550: XMLELEMENT("Code",CAT.CONCATENATED_SEGMENTS),x_temp))))
551: INTO x_doc
552: FROM MTL_CATEGORIES_B_KFV CAT
553: WHERE CAT.CATEGORY_ID =catId;
554:
555:
556: EXCEPTION

Line 662: FROM MTL_CATEGORIES_B_KFV CAT

658: SELECT
659: XMLELEMENT("ClassificationCode",
660: XMLATTRIBUTES(CAT.CONCATENATED_SEGMENTS AS "Name"),parentCategoryId)
661: INTO x_temp1
662: FROM MTL_CATEGORIES_B_KFV CAT
663: WHERE CAT.CATEGORY_ID = parentCategoryId;
664: END IF;
665:
666: ----- Generate ChildClassificationCode Element if categoryId is not NULL -----

Line 673: FROM MTL_CATEGORIES_B_KFV CAT

669:
670: SELECT XMLELEMENT("ChildClassificationCode",
671: XMLATTRIBUTES(CAT.CONCATENATED_SEGMENTS AS "Name"),categoryId)
672: INTO x_temp2
673: FROM MTL_CATEGORIES_B_KFV CAT
674: WHERE CAT.CATEGORY_ID = categoryId;
675: END IF;
676:
677: ------------- Generate CatalogClassification ELEMENT -----------------