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 DUAL

Line 553: dual;

549: null
550: INTO
551: pg_batch_options
552: FROM
553: dual;
554: /*
555: l_Token_Tbl(1).token_name := 'BATCH_ID';
556: l_Token_Tbl(1).token_value := p_batch_id;
557: Error_Handler.Add_Error_Token

Line 1811: FROM dual;

1807: END IF;
1808:
1809: SELECT userenv('LANG')
1810: INTO l_language
1811: FROM dual;
1812:
1813: l_user_id := FND_GLOBAL.USER_ID;
1814: l_resp_id := FND_GLOBAL.RESP_ID;
1815: l_app_id := FND_GLOBAL.RESP_APPL_ID;

Line 2233: l_eff_sql := l_eff_sql || ' FROM DUAL '

2229: l_eff_sql := l_eff_sql || '''' || l_from_rev_pdh || '''';
2230: ELSE
2231: l_eff_sql := l_eff_sql || ' null ' ;
2232: END IF;
2233: l_eff_sql := l_eff_sql || ' FROM DUAL '
2234: || ' UNION ALL SELECT '
2235: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_REVISION_EFF'||'''), '
2236: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '
2237: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_TO_END_ITEM_REV_LABEL'||'''), '

Line 2250: l_eff_sql := l_eff_sql || ' FROM DUAL ';

2246: l_eff_sql := l_eff_sql || '''' || l_to_item_rev_pdh || '''';
2247: ELSE
2248: l_eff_sql := l_eff_sql || ' null ' ;
2249: END IF;
2250: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2251: ELSIF (l_new_from_num_intf IS NOT NULL OR l_from_num_intf IS NOT NULL) THEN
2252: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2253: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '
2254: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_FROM_NUMBER'||'''), '

Line 2268: l_eff_sql := l_eff_sql || ' FROM DUAL '

2264: l_eff_sql := l_eff_sql || '''' || l_from_num_pdh || '''';
2265: ELSE
2266: l_eff_sql := l_eff_sql || ' null ' ;
2267: END IF;
2268: l_eff_sql := l_eff_sql || ' FROM DUAL '
2269: || ' UNION ALL SELECT '
2270: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_UNIT_EFF'||'''), '
2271: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '
2272: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_TO_NUMBER'||'''), '

Line 2284: l_eff_sql := l_eff_sql || ' FROM DUAL ';

2280: l_eff_sql := l_eff_sql || '''' || l_to_unit_num_pdh || '''' ;
2281: ELSE
2282: l_eff_sql := l_eff_sql || ' NULL ';
2283: END IF;
2284: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2285: ELSE
2286: l_eff_sql := l_eff_sql || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2287: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '
2288: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFFECTIVITY_DATE'||'''), '

Line 2303: l_eff_sql := l_eff_sql || ' FROM DUAL '

2299: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_eff_date_pdh) || '''';
2300: ELSE
2301: l_eff_sql := l_eff_sql || ' NULL ' ;
2302: END IF;
2303: l_eff_sql := l_eff_sql || ' FROM DUAL '
2304: || ' UNION ALL SELECT '
2305: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_EFF_DATE_CHOICE'||'''), '
2306: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '
2307: || ' Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_DISABLE_DATE'||'''), '

Line 2319: l_eff_sql := l_eff_sql || ' FROM DUAL ';

2315: l_eff_sql := l_eff_sql || '''' || FND_DATE.DATE_TO_DISPLAYDT(l_dis_date_pdh) || '''';
2316: ELSE
2317: l_eff_sql := l_eff_sql || ' NULL ';
2318: END IF;
2319: l_eff_sql := l_eff_sql || ' FROM DUAL ';
2320:
2321: END IF;
2322:
2323: l_attr_sql := l_eff_sql || ' UNION ALL ';

Line 2382: l_attr_sql := l_attr_sql || '''' || attr.attr_name || ''',(SELECT null from dual),';

2378: attr.attr_group_id || ' or attr_group_int_name = '|| ''''||attr.attr_group_name || ''' ) and attr_int_name = ' || '''' || attr.attr_name || ''' ),';*/
2379: END IF;
2380:
2381: EXCEPTION WHEN NO_DATA_FOUND THEN
2382: l_attr_sql := l_attr_sql || '''' || attr.attr_name || ''',(SELECT null from dual),';
2383: END;
2384:
2385: END IF;--l_dummy not null
2386:

Line 2435: l_attr_sql := l_attr_sql || '''' || attr.attr_name || ''' ,(SELECT null from dual),';

2431: --|| ' AND attr_group_id = ' || attr.attr_group_id || '),';
2432: END IF;
2433:
2434: EXCEPTION WHEN NO_DATA_FOUND THEN
2435: l_attr_sql := l_attr_sql || '''' || attr.attr_name || ''' ,(SELECT null from dual),';
2436: END;
2437:
2438: END IF;--l_dummy
2439:

Line 2470: l_pdh_query := l_pdh_query|| ' from dual ';

2466: END IF;
2467: END IF;
2468: END LOOP;
2469: l_pdh_query := SUBSTR(l_pdh_query, 1, LENGTH(l_pdh_query)-1);
2470: l_pdh_query := l_pdh_query|| ' from dual ';
2471: l_pdh_query := l_pdh_query || ' ) pdh_value ';
2472: END IF;
2473:
2474: IF p_ss_record_id IS NOT NULL

Line 2493: l_src_query := l_src_query || ' from dual ) src_val, ';

2489: END IF;
2490: END IF;
2491: END LOOP;
2492: l_src_query := SUBSTR(l_src_query, 1, LENGTH(l_src_query)-1);
2493: l_src_query := l_src_query || ' from dual ) src_val, ';
2494: END IF;
2495: IF p_comp_seq_id IS NOT NULL THEN
2496: l_where_clause := ' WHERE ((BCEB.component_sequence_id = :9 AND BCEB.structure_type_id = :4 AND attr.attr_group_id = BCEB.ATTR_GROUP_ID) AND (';
2497: ELSE

Line 2529: ||',bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' ;

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 '
2529: ||',bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' ;
2530:
2531: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';
2532: ||'bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),');*/
2533: --dinu_log_message(' bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' );

Line 2533: --dinu_log_message(' bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' );

2529: ||',bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' ;
2530:
2531: /*dinu_log_message(' UNION ALL SELECT Bom_Globals.Retrieve_Message('|| '''' || 'BOM' || ''','||''''|| 'BOM_IMPORT_REF_DESGS'||'''),null,' || p_batch_id || ' batch_identifier ,';
2532: ||'bom_import_pub.get_ref_desgs(:1,:2,:3,1,:5,:6,:7,:8),');*/
2533: --dinu_log_message(' bom_import_pub.get_ref_desgs(:1,:2,:3,null,:5,:6,:7,:8) from dual' );
2534:
2535:
2536: l_dummy := NULL;
2537:

Line 3001: ' structure_type_id , null DATA_LEVEL_COLUMN, '|| p_transaction_id || ' transaction_id FROM dual ';

2997: */
2998:
2999: l_target_sql := 'SELECT ' || l_comp_seq_id || ' component_sequence_id , ' || l_bill_seq_id ||
3000: ' bill_sequence_id, ' || pG_batch_options.structure_type_id ||
3001: ' structure_type_id , null DATA_LEVEL_COLUMN, '|| p_transaction_id || ' transaction_id FROM dual ';
3002:
3003: l_add_class := 'SELECT bst.structure_type_id FROM BOM_STRUCTURE_TYPES_B bst START WITH bst.structure_type_id = ' || pG_batch_options.structure_type_id || ' CONNECT BY PRIOR bst.parent_structure_type_id = bst.structure_type_id ';
3004:
3005:

Line 4711: FROM DUAL;

4707: SELECT
4708: MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
4709: INTO
4710: L_NEXT_VALUE
4711: FROM DUAL;
4712: RETURN L_NEXT_VALUE;
4713: EXCEPTION
4714: WHEN OTHERS THEN
4715: RETURN 0;