APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FA_CATEGORIES

Line 131: fa_categories cat,

127: ad.asset_category_id,
128: ad.parent_asset_id,
129: ad.asset_key_ccid
130: FROM fa_additions ad,
131: fa_categories cat,
132: fa_categories cat1,
133: FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
134: fnd_flex_value_sets val_set,
135: fa_asset_keywords ak

Line 132: fa_categories cat1,

128: ad.parent_asset_id,
129: ad.asset_key_ccid
130: FROM fa_additions ad,
131: fa_categories cat,
132: fa_categories cat1,
133: FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
134: fnd_flex_value_sets val_set,
135: fa_asset_keywords ak
136: WHERE ad.ASSET_CATEGORY_ID = cat.CATEGORY_ID

Line 664: FROM fa_categories

660: l_cat_segment (4),
661: l_cat_segment (5),
662: l_cat_segment (6),
663: l_cat_segment (7)
664: FROM fa_categories
665: WHERE category_id = l_mass_add_rec.asset_category_id;
666:
667: l_major_category := l_cat_segment (l_major_cat_seg_index);
668:

Line 892: FROM fa_categories

888:
889: BEGIN
890: SELECT DISTINCT category_id
891: INTO l_cat_id
892: FROM fa_categories
893: WHERE DECODE (l_cat_segment (1), NULL, '-1', segment1) =
894: DECODE (l_cat_segment (1),
895: NULL, '-1',
896: l_cat_segment (1))

Line 969: FROM fa_categories cat, fa_categories cat1

965: ELSIF (l_temp = 0) THEN
966: BEGIN
967: SELECT DISTINCT cat.category_id
968: INTO l_group_category_id
969: FROM fa_categories cat, fa_categories cat1
970: WHERE cat.SEGMENT2 = l_cat_grp_seg_val
971: AND cat1.category_id = l_category_id
972: AND cat1.segment1 = cat.segment1
973: AND EXISTS

Line 1119: FROM fa_categories cat, fa_categories cat1

1115:
1116: BEGIN
1117: SELECT DISTINCT cat.category_id
1118: INTO l_group_category_id
1119: FROM fa_categories cat, fa_categories cat1
1120: WHERE cat.SEGMENT2 = l_cat_grp_seg_val
1121: AND cat1.category_id = l_category_id
1122: AND cat1.segment1 = cat.segment1
1123: AND EXISTS