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.BOMPCHDU dependencies on SO_LINES_ALL

Line 289: so_lines_all solp, /* Parent of ATO Model if any */

285: update mtl_demand m
286: set m.duplicated_config_item_id = (
287: select BAC1.config_item_id
288: from BOM_ATO_CONFIGURATIONS BAC1, /* the duplicate */
289: so_lines_all solp, /* Parent of ATO Model if any */
290: so_lines_all sol1, /* processing */
291: mtl_system_items msi,
292: bom_operational_routings bor,
293: bom_parameters bp

Line 290: so_lines_all sol1, /* processing */

286: set m.duplicated_config_item_id = (
287: select BAC1.config_item_id
288: from BOM_ATO_CONFIGURATIONS BAC1, /* the duplicate */
289: so_lines_all solp, /* Parent of ATO Model if any */
290: so_lines_all sol1, /* processing */
291: mtl_system_items msi,
292: bom_operational_routings bor,
293: bom_parameters bp
294: where BAC1.base_model_id = sol1.inventory_item_id

Line 304: from so_lines_all sol5 /* current */

300: and msi.organization_id = BAC1.organization_id
301: and msi.inventory_item_id = BAC1.config_item_id
302: and msi.inventory_item_status_code <> bp.bom_delete_status_code
303: and not exists (select 'X'
304: from so_lines_all sol5 /* current */
305: where sol5.ato_line_id = sol1.line_id
306: and sol5.ordered_quantity > nvl(sol5.cancelled_quantity,0)
307: and sol5.inventory_item_id not in
308: (select BAC2.component_item_id

Line 327: from so_lines_all sol7 /* processing */

323: from BOM_ATO_CONFIGURATIONS BAC3 /* duplicates */
324: where BAC3.config_item_id = BAC1.config_item_id
325: and BAC3.component_item_id <> BAC1.component_item_id
326: having count(*) = (select count (*)
327: from so_lines_all sol7 /* processing */
328: where sol7.ato_line_id = sol1.line_id
329: and sol7.ordered_quantity>nvl(sol7.cancelled_quantity,0)
330: )
331: )

Line 375: table_name := 'SO_LINES_ALL';

371:
372: error_message := 'BOMPCHDU' || to_char(stmt_num) || ':' ||
373: substrb(sqlerrm,1,150);
374: message_name := 'BOM_ATO_PROCESS_ERROR';
375: table_name := 'SO_LINES_ALL';
376: return(0);
377: end;
378:
379:

Line 410: from so_lines_all soldp, /* parent of duplicate */

406: m.duplicated_config_demand_id = dupl_demand_id
407: where m.config_group_id = USERENV('SESSIONID')
408: and m.demand_id in (
409: select m1.demand_id
410: from so_lines_all soldp, /* parent of duplicate */
411: so_lines_all solp, /* parent of other lines */
412: so_lines_all sol1, /* processing other lines */
413: so_lines_all sold, /* current -- duplicate */
414: mtl_demand m1

Line 411: so_lines_all solp, /* parent of other lines */

407: where m.config_group_id = USERENV('SESSIONID')
408: and m.demand_id in (
409: select m1.demand_id
410: from so_lines_all soldp, /* parent of duplicate */
411: so_lines_all solp, /* parent of other lines */
412: so_lines_all sol1, /* processing other lines */
413: so_lines_all sold, /* current -- duplicate */
414: mtl_demand m1
415: where sol1.line_id=m1.demand_source_line

Line 412: so_lines_all sol1, /* processing other lines */

408: and m.demand_id in (
409: select m1.demand_id
410: from so_lines_all soldp, /* parent of duplicate */
411: so_lines_all solp, /* parent of other lines */
412: so_lines_all sol1, /* processing other lines */
413: so_lines_all sold, /* current -- duplicate */
414: mtl_demand m1
415: where sol1.line_id=m1.demand_source_line
416: and m1.config_group_id = USERENV('SESSIONID')

Line 413: so_lines_all sold, /* current -- duplicate */

409: select m1.demand_id
410: from so_lines_all soldp, /* parent of duplicate */
411: so_lines_all solp, /* parent of other lines */
412: so_lines_all sol1, /* processing other lines */
413: so_lines_all sold, /* current -- duplicate */
414: mtl_demand m1
415: where sol1.line_id=m1.demand_source_line
416: and m1.config_group_id = USERENV('SESSIONID')
417: and m1.demand_id <> input_demand_id

Line 427: from so_lines_all sold3 /* duplicates */

423: and m1.config_status = 20
424: and m1.duplicated_config_item_id is null
425: and m1.duplicated_config_demand_id is null
426: and exists(select 'X'
427: from so_lines_all sold3 /* duplicates */
428: where sold3.ato_line_id = sold.line_id
429: and sold3.ordered_quantity>nvl(sold3.cancelled_quantity,0)
430: having count(*) = (select count (*)
431: from so_lines_all sol7 /* processing */

Line 431: from so_lines_all sol7 /* processing */

427: from so_lines_all sold3 /* duplicates */
428: where sold3.ato_line_id = sold.line_id
429: and sold3.ordered_quantity>nvl(sold3.cancelled_quantity,0)
430: having count(*) = (select count (*)
431: from so_lines_all sol7 /* processing */
432: where sol7.ato_line_id = sol1.line_id
433: and sol7.ordered_quantity>nvl(sol7.cancelled_quantity,0)
434: )
435: )

Line 437: from so_lines_all sol5 /* current */

433: and sol7.ordered_quantity>nvl(sol7.cancelled_quantity,0)
434: )
435: )
436: and not exists (select 'X'
437: from so_lines_all sol5 /* current */
438: where sol5.ato_line_id = sol1.line_id
439: and sol5.ordered_quantity > nvl(sol5.cancelled_quantity,0)
440: and sol5.inventory_item_id not in
441: (select sold2.inventory_item_id

Line 442: from so_lines_all sold2 /* duplicates */

438: where sol5.ato_line_id = sol1.line_id
439: and sol5.ordered_quantity > nvl(sol5.cancelled_quantity,0)
440: and sol5.inventory_item_id not in
441: (select sold2.inventory_item_id
442: from so_lines_all sold2 /* duplicates */
443: where sold2.ato_line_id = sold.line_id
444: and sold2.component_code = sol5.component_code
445: and decode(sold.link_to_line_id,NULL,sold2.component_code,
446: substrb(sold2.component_code,

Line 478: table_name := 'SO_LINES_ALL';

474:
475: error_message := 'BOMPCHDU' || to_char(stmt_num) || ':' ||
476: substrb(sqlerrm,1,150);
477: message_name := 'BOM_ATO_PROCESS_ERROR';
478: table_name := 'SO_LINES_ALL';
479: return(0);
480: end;
481:
482: