APPS.MTH_ITEM_DIMENSION_PKG dependencies on MTH_ITEM_CATEGORIES_D

Line 94: from MTH_ITEM_CATEGORIES_D

90: end;
91:
92: BEGIN
93: select CATEGORY_NAME into v_unassigned_category_name
94: from MTH_ITEM_CATEGORIES_D
95: where CATEGORY_PK_KEY = v_unassigned_key;
96: exception
97: when TOO_MANY_ROWS then
98: v_unassigned_item_name := null;

Line 1060: from MTH_ITEM_CATEGORIES_D

1056: end;
1057:
1058: BEGIN
1059: select CATEGORY_NAME into v_unassigned_category_name
1060: from MTH_ITEM_CATEGORIES_D
1061: where CATEGORY_PK_KEY = v_unassigned_key;
1062: exception
1063: when TOO_MANY_ROWS then
1064: v_unassigned_item_name := null;

Line 1999: mth_item_categories_d bb,

1995: START WITH B.ITEM_PK_KEY IS NOT NULL AND
1996: B.ITEM_PK_KEY IN
1997: (SELECT c.item_fk_key
1998: FROM mth_item_hierarchy a ,
1999: mth_item_categories_d bb,
2000: mth_item_denorm_d c
2001: WHERE (a.level_fk_key = c.level9_fk_key OR
2002: a.level_fk_key = c.level8_fk_key OR
2003: a.level_fk_key = c.level7_fk_key OR

Line 4019: from MTH_ITEM_CATEGORIES_D

4015: end;
4016:
4017: BEGIN
4018: select CATEGORY_NAME into v_unassigned_category_name
4019: from MTH_ITEM_CATEGORIES_D
4020: where CATEGORY_PK_KEY = v_unassigned_key;
4021: exception
4022: when TOO_MANY_ROWS then
4023: v_unassigned_item_name := null;