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 2481: FOR attr IN (SELECT * FROM bom_attrs_v)

2477: END IF;
2478:
2479: l_temp_count := 1;
2480: l_name_count := 1;
2481: FOR attr IN (SELECT * FROM bom_attrs_v)
2482: LOOP
2483: IF attr.attr_group_type = 'BOM_COMPONENTMGMT_GROUP'
2484: THEN
2485: OPEN Get_Src_Attr(p_str_type_id,attr.attr_group_id,attr.attr_group_name);

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

2544: l_attr_sql1 := SUBSTR(l_attr_sql1,1,LENGTH(l_attr_sql1)-1) || ' ) src_attr_value, decode(attrs.database_column, ';
2545:
2546: l_temp_count := 1;
2547:
2548: FOR attr IN (SELECT * FROM bom_attrs_v )
2549: LOOP
2550: IF attr.attr_group_type = 'BOM_COMPONENTMGMT_GROUP'
2551: THEN
2552: OPEN Get_Attr_Details(p_str_type_id,attr.attr_group_id);

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

2601: THEN
2602: l_pdh_query := ' (SELECT * FROM bom_components_b WHERE component_sequence_id = :3 ) pdh_value' ;
2603: ELSE
2604: l_pdh_query := '(SELECT ';
2605: FOR attr IN (SELECT * FROM bom_attrs_v)
2606: LOOP
2607: IF attr.attr_group_type <> 'BOM_COMPONENTMGMT_GROUP'
2608: THEN
2609: IF attr.attr_group_type = 'BOM_COMPONENT_BASE' THEN

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

2624: ' AND organization_id = ' || p_org_id ||
2625: ' ) ) src_val ,';
2626: ELSE
2627: l_src_query := '(SELECT ';
2628: FOR attr IN (SELECT * FROM bom_attrs_v)
2629: LOOP
2630: IF attr.attr_group_type <> 'BOM_COMPONENTMGMT_GROUP'
2631: THEN
2632: IF attr.attr_group_type = 'BOM_COMPONENT_BASE' THEN

Line 2659: 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 ;

2655: || ' 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 = '
2656: || ' attr.attr_group_id OR BCUA.attr_group_int_name = attr.attr_group_name )))';*/
2657:
2658: --dinu_log_message(l_attr_sql);
2659: 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 ;
2660: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);
2661:
2662: l_attr_sql := l_attr_sql || ' UNION ALL ' || l_attr_sql1
2663: || ' 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 2660: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);

2656: || ' attr.attr_group_id OR BCUA.attr_group_int_name = attr.attr_group_name )))';*/
2657:
2658: --dinu_log_message(l_attr_sql);
2659: 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 ;
2660: --dinu_log_message(' FROM bom_attrs_v attr, bom_components_ext_b BCEB '||l_where_clause);
2661:
2662: l_attr_sql := l_attr_sql || ' UNION ALL ' || l_attr_sql1
2663: || ' 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,'
2664: || '(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 2669: --dinu_log_message(' FROM bom_attrs_v attr,');

2665: || l_src_query || l_pdh_query ||
2666: ' WHERE attrs.attr_group_name = grps.attr_group_name';
2667: --dinu_log_message(' UNION ALL ' );
2668: --dinu_log_message(l_attr_sql1 );
2669: --dinu_log_message(' FROM bom_attrs_v attr,');
2670: --dinu_log_message(l_src_query );
2671: --dinu_log_message(l_pdh_query );
2672: --dinu_log_message( ' WHERE attr.attr_group_type = '|| '''' || 'BOM_COMPONENT_BASE'||'''' );
2673: 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 '