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 2191: FROM bom_components_ext_b BCEB

2187:
2188: CURSOR Get_Attr_Details(p_str_type_id IN NUMBER,p_attr_grp_id IN NUMBER)
2189: IS
2190: SELECT BCEB.component_sequence_id
2191: FROM bom_components_ext_b BCEB
2192: WHERE BCEB.structure_type_id = p_str_type_id
2193: AND BCEB.attr_group_id = p_attr_grp_id;
2194:
2195: CURSOR Get_Src_Attr(p_str_type_id IN NUMBER,p_attr_grp_id IN NUMBER,p_attr_grp_name IN VARCHAR2)

Line 2423: FROM bom_components_ext_b BCEB

2419:
2420: BEGIN
2421: SELECT 'Exist'
2422: INTO l_dummy
2423: FROM bom_components_ext_b BCEB
2424: WHERE BCEB.component_sequence_id = p_comp_seq_id
2425: AND BCEB.attr_group_id = attr.attr_group_id;
2426:
2427: IF l_dummy IS NOT NULL

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

2426:
2427: IF l_dummy IS NOT NULL
2428: THEN
2429: l_attr_sql := l_attr_sql || '''' || attr.attr_name || ''' ,BCEB.' ||attr.database_column || ',';
2430: --(SELECT to_char(' || attr.database_column || ') FROM bom_components_ext_b where component_sequence_id = '|| p_comp_seq_id
2431: --|| ' AND attr_group_id = ' || attr.attr_group_id || '),';
2432: END IF;
2433:
2434: EXCEPTION WHEN NO_DATA_FOUND 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,'