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 584: bom_departments b, -- from op's dept

580: a.show_lot_attrib,
581: a.track_multiple_res_usage_dates,
582: a.check_skill --added for bug 7597474
583: FROM bom_operation_sequences a, -- from op
584: bom_departments b, -- from op's dept
585: bom_departments c -- to op's dept
586: WHERE a.routing_sequence_id = x_from_sequence_id
587: AND NVL (a.eco_for_production, 2) = 2
588: AND (display_option = 1 /* ALL */

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

581: a.track_multiple_res_usage_dates,
582: a.check_skill --added for bug 7597474
583: FROM bom_operation_sequences a, -- from op
584: bom_departments b, -- from op's dept
585: bom_departments c -- to op's dept
586: WHERE a.routing_sequence_id = x_from_sequence_id
587: AND NVL (a.eco_for_production, 2) = 2
588: AND (display_option = 1 /* ALL */
589: OR (display_option = 2 /* CURRENT */

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

676: NULL,
677: fnd_global.conc_program_id,
678: sysdate
679: FROM bom_operation_sequences a, -- from op
680: bom_departments b, -- from op's dept
681: bom_departments c -- to op's dept
682: WHERE a.routing_sequence_id = x_from_sequence_id
683: AND (display_option = 1 /* ALL */
684: OR (display_option = 2 /* CURRENT */

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

677: fnd_global.conc_program_id,
678: sysdate
679: FROM bom_operation_sequences a, -- from op
680: bom_departments b, -- from op's dept
681: bom_departments c -- to op's dept
682: WHERE a.routing_sequence_id = x_from_sequence_id
683: AND (display_option = 1 /* ALL */
684: OR (display_option = 2 /* CURRENT */
685: AND a.effectivity_date <= rev_date

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

744: NULL,
745: fnd_global.conc_program_id,
746: sysdate
747: FROM bom_operation_sequences a, -- from op
748: bom_departments b, -- from op's dept
749: bom_departments c -- to op's dept
750: WHERE a.routing_sequence_id = x_from_sequence_id
751: AND (display_option = 1 /* ALL */
752: OR (display_option = 2 /* CURRENT */

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

745: fnd_global.conc_program_id,
746: sysdate
747: FROM bom_operation_sequences a, -- from op
748: bom_departments b, -- from op's dept
749: bom_departments c -- to op's dept
750: WHERE a.routing_sequence_id = x_from_sequence_id
751: AND (display_option = 1 /* ALL */
752: OR (display_option = 2 /* CURRENT */
753: AND a.effectivity_date <= rev_date

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

2624: a.show_lot_attrib,
2625: a.track_multiple_res_usage_dates,
2626: a.check_skill --added for bug 7597474
2627: FROM bom_operation_sequences a, -- from op
2628: bom_departments b, -- from op's dept
2629: bom_departments c -- to op's dept
2630: WHERE a.routing_sequence_id = x_from_sequence_id
2631: AND NVL (a.eco_for_production, 2) = 2
2632: AND a.department_id = b.department_id

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

2625: a.track_multiple_res_usage_dates,
2626: a.check_skill --added for bug 7597474
2627: FROM bom_operation_sequences a, -- from op
2628: bom_departments b, -- from op's dept
2629: bom_departments c -- to op's dept
2630: WHERE a.routing_sequence_id = x_from_sequence_id
2631: AND NVL (a.eco_for_production, 2) = 2
2632: AND a.department_id = b.department_id
2633: AND b.department_code = c.department_code

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

2700: NULL,
2701: fnd_global.conc_program_id,
2702: sysdate
2703: FROM bom_operation_sequences a, -- from op
2704: bom_departments b, -- from op's dept
2705: bom_departments c -- to op's dept
2706: WHERE a.routing_sequence_id = x_from_sequence_id
2707: 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
2708: OR ( p_cpy_disable_fields = 'N' AND a.effectivity_date = rev_date )

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

2701: fnd_global.conc_program_id,
2702: sysdate
2703: FROM bom_operation_sequences a, -- from op
2704: bom_departments b, -- from op's dept
2705: bom_departments c -- to op's dept
2706: WHERE a.routing_sequence_id = x_from_sequence_id
2707: 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
2708: OR ( p_cpy_disable_fields = 'N' AND a.effectivity_date = rev_date )
2709: )

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

2748: NULL,
2749: fnd_global.conc_program_id,
2750: sysdate
2751: FROM bom_operation_sequences a, -- from op
2752: bom_departments b -- from op's dept
2753: WHERE a.routing_sequence_id = x_from_sequence_id
2754: 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
2755: OR ( p_cpy_disable_fields = 'N' AND a.effectivity_date = rev_date )
2756: )