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_COMPONENTS_EXT_B

Line 2334: FROM bom_components_ext_b BCEB

2330:
2331: CURSOR Get_Attr_Details(p_str_type_id IN NUMBER,p_attr_grp_id IN NUMBER)
2332: IS
2333: SELECT BCEB.component_sequence_id
2334: FROM bom_components_ext_b BCEB
2335: WHERE BCEB.structure_type_id = p_str_type_id
2336: AND BCEB.attr_group_id = p_attr_grp_id;
2337:
2338: CURSOR Get_Src_Attr(p_str_type_id IN NUMBER,p_attr_grp_id IN NUMBER,p_attr_grp_name IN VARCHAR2)

Line 2568: FROM bom_components_ext_b BCEB

2564:
2565: BEGIN
2566: SELECT 'Exist'
2567: INTO l_dummy
2568: FROM bom_components_ext_b BCEB
2569: WHERE BCEB.component_sequence_id = p_comp_seq_id
2570: AND BCEB.attr_group_id = attr.attr_group_id;
2571:
2572: IF l_dummy IS NOT NULL

Line 2575: --(SELECT to_char(' || attr.database_column || ') FROM bom_components_ext_b where component_sequence_id = '|| p_comp_seq_id

2571:
2572: IF l_dummy IS NOT NULL
2573: THEN
2574: l_attr_sql := l_attr_sql || '''' || attr.attr_name || ''' ,BCEB.' ||attr.database_column || ',';
2575: --(SELECT to_char(' || attr.database_column || ') FROM bom_components_ext_b where component_sequence_id = '|| p_comp_seq_id
2576: --|| ' AND attr_group_id = ' || attr.attr_group_id || '),';
2577: END IF;
2578:
2579: EXCEPTION WHEN NO_DATA_FOUND 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,'