eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_IMPORT_PUB dependencies on BOM_ATTRS_V

Line 2336: FOR attr IN (SELECT * FROM bom_attrs_v)

2332: END IF;
2333:
2334: l_temp_count := 1;
2335: l_name_count := 1;
2336: FOR attr IN (SELECT * FROM bom_attrs_v)
2337: LOOP
2338: IF attr.attr_group_type = 'BOM_COMPONENTMGMT_GROUP'
2339: THEN
2340: OPEN Get_Src_Attr(p_str_type_id,attr.attr_group_id,attr.attr_group_name);

Line 2403: FOR attr IN (SELECT * FROM bom_attrs_v )

2399: l_attr_sql1 := SUBSTR(l_attr_sql1,1,LENGTH(l_attr_sql1)-1) || ' ) src_attr_value, decode(attrs.database_column, ';
2400:
2401: l_temp_count := 1;
2402:
2403: FOR attr IN (SELECT * FROM bom_attrs_v )
2404: LOOP
2405: IF attr.attr_group_type = 'BOM_COMPONENTMGMT_GROUP'
2406: THEN
2407: OPEN Get_Attr_Details(p_str_type_id,attr.attr_group_id);

Line 2460: FOR attr IN (SELECT * FROM bom_attrs_v)

2456: THEN
2457: l_pdh_query := ' (SELECT * FROM bom_components_b WHERE component_sequence_id = :3 ) pdh_value' ;
2458: ELSE
2459: l_pdh_query := '(SELECT ';
2460: FOR attr IN (SELECT * FROM bom_attrs_v)
2461: LOOP
2462: IF attr.attr_group_type <> 'BOM_COMPONENTMGMT_GROUP'
2463: THEN
2464: IF attr.attr_group_type = 'BOM_COMPONENT_BASE' THEN

Line 2483: FOR attr IN (SELECT * FROM bom_attrs_v)

2479: ' AND organization_id = ' || p_org_id ||
2480: ' ) ) src_val ,';
2481: ELSE
2482: l_src_query := '(SELECT ';
2483: FOR attr IN (SELECT * FROM bom_attrs_v)
2484: LOOP
2485: IF attr.attr_group_type <> 'BOM_COMPONENTMGMT_GROUP'
2486: THEN
2487: IF attr.attr_group_type = 'BOM_COMPONENT_BASE' THEN

Line 2514: l_attr_sql := l_attr_sql || ' FROM bom_attrs_v attr, bom_components_ext_b BCEB,bom_cmp_usr_attr_interface BCUA '||l_where_clause ;

2510: || ' BCUA.structure_type_id = '|| p_str_type_id || ' AND BCUA.attr_disp_value IS NOT NULL AND attr.attr_group_type = ' || ''''|| 'BOM_COMPONENTMGMT_GROUP' || ''' AND (BCUA.ATTR_GROUP_ID = '
2511: || ' attr.attr_group_id OR BCUA.attr_group_int_name = attr.attr_group_name )))';*/
2512:
2513: --dinu_log_message(l_attr_sql);
2514: l_attr_sql := l_attr_sql || ' FROM bom_attrs_v attr, bom_components_ext_b BCEB,bom_cmp_usr_attr_interface BCUA '||l_where_clause ;
2515: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);
2516:
2517: l_attr_sql := l_attr_sql || ' UNION ALL ' || l_attr_sql1
2518: || ' FROM (SELECT attr_group_name,attr_group_disp_name FROM ego_attr_groups_v WHERE attr_group_type = '||''''|| 'BOM_COMPONENT_BASE' || ''' AND application_id = 702 ORDER BY attr_group_name) grps,'

Line 2515: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);

2511: || ' attr.attr_group_id OR BCUA.attr_group_int_name = attr.attr_group_name )))';*/
2512:
2513: --dinu_log_message(l_attr_sql);
2514: l_attr_sql := l_attr_sql || ' FROM bom_attrs_v attr, bom_components_ext_b BCEB,bom_cmp_usr_attr_interface BCUA '||l_where_clause ;
2515: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);
2516:
2517: l_attr_sql := l_attr_sql || ' UNION ALL ' || l_attr_sql1
2518: || ' FROM (SELECT attr_group_name,attr_group_disp_name FROM ego_attr_groups_v WHERE attr_group_type = '||''''|| 'BOM_COMPONENT_BASE' || ''' AND application_id = 702 ORDER BY attr_group_name) grps,'
2519: || '(SELECT attr_name,attr_display_name,database_column,attr_group_name FROM ego_attrs_v WHERE attr_group_type = '|| ''''|| 'BOM_COMPONENT_BASE' || ''' AND application_id = 702 ORDER BY attr_group_name) attrs,'

Line 2524: --dinu_log_message(' FROM bom_attrs_v attr,');

2520: || l_src_query || l_pdh_query ||
2521: ' WHERE attrs.attr_group_name = grps.attr_group_name';
2522: --dinu_log_message(' UNION ALL ' );
2523: --dinu_log_message(l_attr_sql1 );
2524: --dinu_log_message(' FROM bom_attrs_v attr,');
2525: --dinu_log_message(l_src_query );
2526: --dinu_log_message(l_pdh_query );
2527: --dinu_log_message( ' WHERE attr.attr_group_type = '|| '''' || 'BOM_COMPONENT_BASE'||'''' );
2528: l_attr_sql := l_attr_sql || ' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,null, ' || p_batch_id || ' batch_identifier '