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_COPY_ROUTING dependencies on BOM_DEPARTMENTS

Line 577: bom_departments b, -- from op's dept

573: a.show_scrap_code,
574: a.show_lot_attrib,
575: a.track_multiple_res_usage_dates
576: FROM bom_operation_sequences a, -- from op
577: bom_departments b, -- from op's dept
578: bom_departments c -- to op's dept
579: WHERE a.routing_sequence_id = x_from_sequence_id
580: AND NVL (a.eco_for_production, 2) = 2
581: AND (display_option = 1 /* ALL */

Line 578: bom_departments c -- to op's dept

574: a.show_lot_attrib,
575: a.track_multiple_res_usage_dates
576: FROM bom_operation_sequences a, -- from op
577: bom_departments b, -- from op's dept
578: bom_departments c -- to op's dept
579: WHERE a.routing_sequence_id = x_from_sequence_id
580: AND NVL (a.eco_for_production, 2) = 2
581: AND (display_option = 1 /* ALL */
582: OR (display_option = 2 /* CURRENT */

Line 673: bom_departments b, -- from op's dept

669: NULL,
670: fnd_global.conc_program_id,
671: sysdate
672: FROM bom_operation_sequences a, -- from op
673: bom_departments b, -- from op's dept
674: bom_departments c -- to op's dept
675: WHERE a.routing_sequence_id = x_from_sequence_id
676: AND (display_option = 1 /* ALL */
677: OR (display_option = 2 /* CURRENT */

Line 674: bom_departments c -- to op's dept

670: fnd_global.conc_program_id,
671: sysdate
672: FROM bom_operation_sequences a, -- from op
673: bom_departments b, -- from op's dept
674: bom_departments c -- to op's dept
675: WHERE a.routing_sequence_id = x_from_sequence_id
676: AND (display_option = 1 /* ALL */
677: OR (display_option = 2 /* CURRENT */
678: AND a.effectivity_date <= rev_date

Line 741: bom_departments b, -- from op's dept

737: NULL,
738: fnd_global.conc_program_id,
739: sysdate
740: FROM bom_operation_sequences a, -- from op
741: bom_departments b, -- from op's dept
742: bom_departments c -- to op's dept
743: WHERE a.routing_sequence_id = x_from_sequence_id
744: AND (display_option = 1 /* ALL */
745: OR (display_option = 2 /* CURRENT */

Line 742: bom_departments c -- to op's dept

738: fnd_global.conc_program_id,
739: sysdate
740: FROM bom_operation_sequences a, -- from op
741: bom_departments b, -- from op's dept
742: bom_departments c -- to op's dept
743: WHERE a.routing_sequence_id = x_from_sequence_id
744: AND (display_option = 1 /* ALL */
745: OR (display_option = 2 /* CURRENT */
746: AND a.effectivity_date <= rev_date

Line 2558: bom_departments b, -- from op's dept

2554: a.show_scrap_code,
2555: a.show_lot_attrib,
2556: a.track_multiple_res_usage_dates
2557: FROM bom_operation_sequences a, -- from op
2558: bom_departments b, -- from op's dept
2559: bom_departments c -- to op's dept
2560: WHERE a.routing_sequence_id = x_from_sequence_id
2561: AND NVL (a.eco_for_production, 2) = 2
2562: AND a.department_id = b.department_id

Line 2559: bom_departments c -- to op's dept

2555: a.show_lot_attrib,
2556: a.track_multiple_res_usage_dates
2557: FROM bom_operation_sequences a, -- from op
2558: bom_departments b, -- from op's dept
2559: bom_departments c -- to op's dept
2560: WHERE a.routing_sequence_id = x_from_sequence_id
2561: AND NVL (a.eco_for_production, 2) = 2
2562: AND a.department_id = b.department_id
2563: AND b.department_code = c.department_code

Line 2634: bom_departments b, -- from op's dept

2630: NULL,
2631: fnd_global.conc_program_id,
2632: sysdate
2633: FROM bom_operation_sequences a, -- from op
2634: bom_departments b, -- from op's dept
2635: bom_departments c -- to op's dept
2636: WHERE a.routing_sequence_id = x_from_sequence_id
2637: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date
2638: OR ( p_cpy_disable_fields = 'N' AND a.effectivity_date = rev_date )

Line 2635: bom_departments c -- to op's dept

2631: fnd_global.conc_program_id,
2632: sysdate
2633: FROM bom_operation_sequences a, -- from op
2634: bom_departments b, -- from op's dept
2635: bom_departments c -- to op's dept
2636: WHERE a.routing_sequence_id = x_from_sequence_id
2637: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date
2638: OR ( p_cpy_disable_fields = 'N' AND a.effectivity_date = rev_date )
2639: )

Line 2682: bom_departments b -- from op's dept

2678: NULL,
2679: fnd_global.conc_program_id,
2680: sysdate
2681: FROM bom_operation_sequences a, -- from op
2682: bom_departments b -- from op's dept
2683: WHERE a.routing_sequence_id = x_from_sequence_id
2684: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date
2685: OR ( p_cpy_disable_fields = 'N' AND a.effectivity_date = rev_date )
2686: )