1334: FROM fnd_application WHERE application_short_name = 'BOM';
1335:
1336: --get context field name
1337: select default_context_field_name, context_column_name into l_context, l_context_column
1338: from FND_DESCRIPTIVE_FLEXS where application_id = l_app_id and
1339: descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS';
1340:
1341: --process further only when reference field is set
1342: if ((l_context_column = 'ATTRIBUTE_CATEGORY') and (l_context is not null)) then
7700: FROM fnd_application WHERE application_short_name = 'BOM';
7701:
7702: --get context field name
7703: select default_context_field_name, context_column_name into l_context, l_context_column
7704: from FND_DESCRIPTIVE_FLEXS where application_id = l_app_id and
7705: descriptive_flexfield_name = 'BOM_INVENTORY_COMPONENTS';
7706:
7707: --process further only when reference field is set
7708: if ((l_context_column = 'ATTRIBUTE_CATEGORY') and (l_context is not null)) then