DBA Data[Home] [Help]

APPS.EGO_CATG_MAP_PKG dependencies on MTL_CATEGORIES_B_KFV

Line 406: FROM MTL_CATEGORIES_B_KFV A,

402: -- getting the source category id by passing the source category_name
403: BEGIN
404: SELECT A.CATEGORY_ID SOURCE_CATG_ID
405: INTO l_source_catg_id
406: FROM MTL_CATEGORIES_B_KFV A,
407: MTL_CATEGORY_SETS B
408: WHERE B.CATEGORY_SET_ID = l_source_catg_set_id
409: AND A.STRUCTURE_ID = B.STRUCTURE_ID
410: AND A.CONCATENATED_SEGMENTS = X_SOURCE_CATG_NAME;

Line 424: FROM MTL_CATEGORIES_B_KFV A,

420: BEGIN
421:
422: SELECT A.CATEGORY_ID TARGET_CATG_ID
423: INTO l_target_catg_id
424: FROM MTL_CATEGORIES_B_KFV A,
425: MTL_CATEGORY_SETS B
426: WHERE B.CATEGORY_SET_ID = l_target_catg_set_id
427: AND A.STRUCTURE_ID = B.STRUCTURE_ID
428: AND A.CONCATENATED_SEGMENTS = X_TARGET_CATG_NAME;