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_SUB_OPERATION_RESOURCES

Line 101: bom_sub_operation_resources c

97: SELECT DISTINCT COUNT (*)
98: INTO total_sub_resources
99: FROM bom_operation_sequences a,
100: bom_operation_resources b,
101: bom_sub_operation_resources c
102: WHERE a.routing_sequence_id = from_rtg_seq_id
103: AND NVL (a.eco_for_production, 2) = 2
104: AND (display_option = 1
105: OR (display_option = 2

Line 1748: INSERT INTO bom_sub_operation_resources

1744:
1745: -- Bug Fix 2991810
1746: sql_stmt_num := 25;
1747:
1748: INSERT INTO bom_sub_operation_resources
1749: (operation_sequence_id,
1750: substitute_group_num,
1751: resource_id,
1752: schedule_seq_num,

Line 1853: bom_sub_operation_resources b,

1849: NULL
1850: --bug 14332194 end
1851: FROM /*BOM_OPERATION_RESOURCES A, Commented for Bug 6828461*/
1852: bom_operation_sequences a, /*Added for Bug 6828461*/
1853: bom_sub_operation_resources b,
1854: bom_resources c,
1855: bom_resources d
1856: WHERE A.ROUTING_SEQUENCE_ID = to_sequence_id /*Added for performance improvement for bug 6828461*/
1857: AND a.last_updated_by = b.operation_sequence_id

Line 1902: bom_sub_operation_resources b,

1898: fnd_global.conc_program_id,
1899: sysdate
1900: FROM bom_operation_resources a,
1901: bom_operation_sequences fbor,
1902: bom_sub_operation_resources b,
1903: bom_resources c,
1904: bom_resources d
1905: WHERE a.last_updated_by = b.operation_sequence_id
1906: AND b.operation_sequence_id = fbor.operation_sequence_id

Line 1932: bom_sub_operation_resources b,

1928: fnd_global.conc_program_id,
1929: sysdate
1930: FROM bom_operation_resources a,
1931: bom_operation_sequences fbor,
1932: bom_sub_operation_resources b,
1933: bom_resources c,
1934: bom_resources d
1935: WHERE a.last_updated_by = b.operation_sequence_id
1936: AND a.created_by = b.schedule_seq_num

Line 1954: UPDATE bom_sub_operation_resources a

1950: IF (from_org_id <> to_org_id)
1951: THEN
1952: sql_stmt_num := 35;
1953:
1954: UPDATE bom_sub_operation_resources a
1955: SET activity_id =
1956: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
1957: FROM cst_activities
1958: WHERE activity_id = a.activity_id),

Line 3646: INSERT INTO bom_sub_operation_resources

3642:
3643: -- Bug Fix 2991810
3644: sql_stmt_num := 25;
3645:
3646: INSERT INTO bom_sub_operation_resources
3647: (operation_sequence_id,
3648: substitute_group_num,
3649: resource_id,
3650: schedule_seq_num,

Line 3749: bom_sub_operation_resources b,

3745: NULL
3746: --bug 14380725 end
3747:
3748: FROM bom_operation_resources a,
3749: bom_sub_operation_resources b,
3750: bom_resources c,
3751: bom_resources d,
3752: bom_operation_sequences bos
3753: WHERE a.last_updated_by = b.operation_sequence_id

Line 3800: bom_sub_operation_resources b,

3796: fnd_global.conc_program_id,
3797: sysdate
3798: FROM bom_operation_resources a,
3799: bom_operation_sequences fbor,
3800: bom_sub_operation_resources b,
3801: bom_resources c,
3802: bom_resources d
3803: WHERE a.last_updated_by = b.operation_sequence_id
3804: AND fbor.revised_item_sequence_id = p_rev_item_seq_id

Line 3831: bom_sub_operation_resources b,

3827: fnd_global.conc_program_id,
3828: sysdate
3829: FROM bom_operation_resources a,
3830: bom_operation_sequences fbor,
3831: bom_sub_operation_resources b,
3832: bom_resources c,
3833: bom_resources d
3834: WHERE a.last_updated_by = b.operation_sequence_id
3835: AND a.created_by = b.schedule_seq_num

Line 3854: UPDATE bom_sub_operation_resources a

3850: IF (from_org_id <> to_org_id)
3851: THEN
3852: sql_stmt_num := 35;
3853:
3854: UPDATE bom_sub_operation_resources a
3855: SET activity_id =
3856: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
3857: FROM cst_activities
3858: WHERE activity_id = a.activity_id),