APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FA_ASSET_KEYWORDS

Line 135: fa_asset_keywords ak

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
137: AND cat.SEGMENT2 = l_cat_value
138: AND cat1.category_id = l_category_id
139: AND cat1.segment1 = cat.segment1

Line 615: FROM fa_asset_keywords

611: l_akey_segment (7),
612: l_akey_segment (8),
613: l_akey_segment (9),
614: l_akey_segment (10)
615: FROM fa_asset_keywords
616: WHERE code_combination_id = l_akey_ccid;
617:
618: l_here_key_seg_val := l_akey_segment (l_here_key_seg_index);
619:

Line 647: FROM fa_asset_keywords

643: l_group_akey_segment7,
644: l_group_akey_segment8,
645: l_group_akey_segment9,
646: l_group_akey_segment10
647: FROM fa_asset_keywords
648: WHERE code_combination_id = l_child_akey_ccid;
649:
650: SELECT segment1,
651: segment2,

Line 676: FROM fa_asset_keywords

672:
673: BEGIN
674: SELECT code_combination_id
675: INTO l_akey_ccid
676: FROM fa_asset_keywords
677: WHERE NVL (segment1, '-1') = NVL (l_group_akey_segment1, '-1')
678: AND NVL (segment2, '-1') = 'PARENT'
679: AND NVL (segment3, '-1') =
680: NVL (l_group_akey_segment3, '-1')

Line 697: SELECT FA_Asset_keywords_S.NEXTVAL

693: AND NVL (segment10, '-1') =
694: NVL (l_group_akey_segment10, '-1');
695: EXCEPTION
696: WHEN NO_DATA_FOUND THEN
697: SELECT FA_Asset_keywords_S.NEXTVAL
698: INTO akey_ccid_seq
699: FROM DUAL;
700:
701: INSERT INTO fa_asset_keywords (CODE_COMBINATION_ID,

Line 701: INSERT INTO fa_asset_keywords (CODE_COMBINATION_ID,

697: SELECT FA_Asset_keywords_S.NEXTVAL
698: INTO akey_ccid_seq
699: FROM DUAL;
700:
701: INSERT INTO fa_asset_keywords (CODE_COMBINATION_ID,
702: SEGMENT1,
703: SEGMENT2,
704: SEGMENT3,
705: SEGMENT4,

Line 759: FROM fa_asset_keywords

755: l_group_akey_segment7,
756: l_group_akey_segment8,
757: l_group_akey_segment9,
758: l_group_akey_segment10
759: FROM fa_asset_keywords
760: WHERE code_combination_id = l_child_akey_ccid;
761:
762:
763: SELECT DISTINCT ak.code_combination_id

Line 767: fa_asset_keywords ak

763: SELECT DISTINCT ak.code_combination_id
764: INTO l_akey_ccid
765: FROM FND_FLEX_VALUE_NORM_HIERARCHY val_norm,
766: fnd_flex_value_sets val_set,
767: fa_asset_keywords ak
768: WHERE val_norm.flex_value_set_id =
769: val_set.flex_value_set_id
770: AND val_set.flex_value_set_name = l_value_set_name
771: AND l_here_key_seg_val BETWEEN val_norm.child_flex_value_low

Line 809: FROM fa_asset_keywords

805: AND val_norm.child_flex_value_high;
806:
807: SELECT DISTINCT code_combination_id
808: INTO l_akey_ccid
809: FROM fa_asset_keywords
810: WHERE NVL (segment1, '-1') =
811: NVL (l_group_akey_segment1, '-1')
812: AND NVL (segment2, '-1') = 'PARENT'
813: AND NVL (segment3, '-1') =

Line 831: SELECT FA_Asset_keywords_S.NEXTVAL

827: AND NVL (segment10, '-1') =
828: NVL (l_group_akey_segment10, '-1');
829: EXCEPTION
830: WHEN NO_DATA_FOUND THEN
831: SELECT FA_Asset_keywords_S.NEXTVAL
832: INTO akey_ccid_seq
833: FROM DUAL;
834:
835: INSERT

Line 836: INTO fa_asset_keywords (CODE_COMBINATION_ID,

832: INTO akey_ccid_seq
833: FROM DUAL;
834:
835: INSERT
836: INTO fa_asset_keywords (CODE_COMBINATION_ID,
837: SEGMENT1,
838: SEGMENT2,
839: SEGMENT3,
840: SEGMENT4,