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_RESOURCES

Line 1601: bom_resources c,

1597: NULL --b.original_system_reference
1598: --bug 14332194 end
1599: FROM bom_operation_sequences a,
1600: bom_operation_resources b,
1601: bom_resources c,
1602: bom_resources d
1603: -- ,BOM_DEPARTMENT_RESOURCES E
1604: WHERE a.routing_sequence_id = to_sequence_id
1605: AND a.last_updated_by = b.operation_sequence_id

Line 1602: bom_resources d

1598: --bug 14332194 end
1599: FROM bom_operation_sequences a,
1600: bom_operation_resources b,
1601: bom_resources c,
1602: bom_resources d
1603: -- ,BOM_DEPARTMENT_RESOURCES E
1604: WHERE a.routing_sequence_id = to_sequence_id
1605: AND a.last_updated_by = b.operation_sequence_id
1606: AND b.resource_id = c.resource_id

Line 1652: bom_resources c,

1648: sysdate
1649: FROM bom_operation_sequences a,
1650: bom_operation_resources b,
1651: bom_operation_sequences fbor,
1652: bom_resources c,
1653: bom_resources d
1654: WHERE a.routing_sequence_id = to_sequence_id
1655: AND a.last_updated_by = b.operation_sequence_id
1656: AND b.resource_id = c.resource_id

Line 1653: bom_resources d

1649: FROM bom_operation_sequences a,
1650: bom_operation_resources b,
1651: bom_operation_sequences fbor,
1652: bom_resources c,
1653: bom_resources d
1654: WHERE a.routing_sequence_id = to_sequence_id
1655: AND a.last_updated_by = b.operation_sequence_id
1656: AND b.resource_id = c.resource_id
1657: AND c.resource_code = d.resource_code(+)

Line 1682: bom_resources c,

1678: sysdate
1679: FROM bom_operation_sequences a,
1680: bom_operation_resources b,
1681: bom_operation_sequences fbor,
1682: bom_resources c,
1683: bom_resources d
1684: WHERE a.routing_sequence_id = to_sequence_id
1685: AND a.last_updated_by = b.operation_sequence_id
1686: AND b.resource_id = c.resource_id

Line 1683: bom_resources d

1679: FROM bom_operation_sequences a,
1680: bom_operation_resources b,
1681: bom_operation_sequences fbor,
1682: bom_resources c,
1683: bom_resources d
1684: WHERE a.routing_sequence_id = to_sequence_id
1685: AND a.last_updated_by = b.operation_sequence_id
1686: AND b.resource_id = c.resource_id
1687: AND c.resource_code = d.resource_code

Line 1726: bom_resources c

1722: 2
1723: )
1724: )
1725: FROM mtl_units_of_measure b,
1726: bom_resources c
1727: WHERE a.resource_id = c.resource_id
1728: AND c.unit_of_measure = b.uom_code(+)), -- modified from b.unit_of_messure to b.uom_code for bug 10362130
1729: setup_id =
1730: (SELECT brs.setup_id

Line 1854: bom_resources c,

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
1858: -- AND a.created_by = b.schedule_seq_num Bug No 6407518

Line 1855: bom_resources d

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
1858: -- AND a.created_by = b.schedule_seq_num Bug No 6407518
1859: AND b.resource_id = c.resource_id

Line 1903: bom_resources c,

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
1907: AND a.created_by = b.schedule_seq_num

Line 1904: bom_resources d

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
1907: AND a.created_by = b.schedule_seq_num
1908: AND b.resource_id = c.resource_id

Line 1933: bom_resources c,

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
1937: AND b.operation_sequence_id = fbor.operation_sequence_id

Line 1934: bom_resources d

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
1937: AND b.operation_sequence_id = fbor.operation_sequence_id
1938: AND b.resource_id = c.resource_id

Line 1969: bom_resources c

1965: 2
1966: )
1967: )
1968: FROM mtl_units_of_measure b,
1969: bom_resources c
1970: WHERE a.resource_id = c.resource_id
1971: AND c.unit_of_measure = b.uom_code(+)), -- modified from b.unit_of_messure to b.uom_code for bug 10362130
1972: setup_id =
1973: (SELECT brs.setup_id

Line 3496: bom_resources c,

3492: NULL
3493: --bug 14380725 end
3494: FROM bom_operation_sequences a,
3495: bom_operation_resources b,
3496: bom_resources c,
3497: bom_resources d
3498: -- ,BOM_DEPARTMENT_RESOURCES E
3499: WHERE a.routing_sequence_id = to_sequence_id
3500: AND a.last_updated_by = b.operation_sequence_id

Line 3497: bom_resources d

3493: --bug 14380725 end
3494: FROM bom_operation_sequences a,
3495: bom_operation_resources b,
3496: bom_resources c,
3497: bom_resources d
3498: -- ,BOM_DEPARTMENT_RESOURCES E
3499: WHERE a.routing_sequence_id = to_sequence_id
3500: AND a.last_updated_by = b.operation_sequence_id
3501: AND b.resource_id = c.resource_id

Line 3548: bom_resources c,

3544: sysdate
3545: FROM bom_operation_sequences a,
3546: bom_operation_resources b,
3547: bom_operation_sequences fbor,
3548: bom_resources c,
3549: bom_resources d
3550: WHERE a.routing_sequence_id = to_sequence_id
3551: AND a.last_updated_by = b.operation_sequence_id
3552: AND b.resource_id = c.resource_id

Line 3549: bom_resources d

3545: FROM bom_operation_sequences a,
3546: bom_operation_resources b,
3547: bom_operation_sequences fbor,
3548: bom_resources c,
3549: bom_resources d
3550: WHERE a.routing_sequence_id = to_sequence_id
3551: AND a.last_updated_by = b.operation_sequence_id
3552: AND b.resource_id = c.resource_id
3553: AND c.resource_code = d.resource_code(+)

Line 3579: bom_resources c,

3575: sysdate
3576: FROM bom_operation_sequences a,
3577: bom_operation_resources b,
3578: bom_operation_sequences fbor,
3579: bom_resources c,
3580: bom_resources d
3581: WHERE a.routing_sequence_id = to_sequence_id
3582: AND a.last_updated_by = b.operation_sequence_id
3583: AND b.resource_id = c.resource_id

Line 3580: bom_resources d

3576: FROM bom_operation_sequences a,
3577: bom_operation_resources b,
3578: bom_operation_sequences fbor,
3579: bom_resources c,
3580: bom_resources d
3581: WHERE a.routing_sequence_id = to_sequence_id
3582: AND a.last_updated_by = b.operation_sequence_id
3583: AND b.resource_id = c.resource_id
3584: AND c.resource_code = d.resource_code

Line 3624: bom_resources c

3620: 2
3621: )
3622: )
3623: FROM mtl_units_of_measure b,
3624: bom_resources c
3625: WHERE a.resource_id = c.resource_id
3626: AND c.unit_of_measure = b.uom_code(+)), -- modified from b.unit_of_messure to b.uom_code for bug 10362130
3627: setup_id =
3628: (SELECT brs.setup_id

Line 3750: bom_resources c,

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
3754: AND bos.operation_sequence_id = b.operation_sequence_id

Line 3751: bom_resources d,

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
3754: AND bos.operation_sequence_id = b.operation_sequence_id
3755: AND bos.revised_item_sequence_id = p_rev_item_seq_id

Line 3801: bom_resources c,

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
3805: AND b.operation_sequence_id = fbor.operation_sequence_id

Line 3802: bom_resources d

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
3805: AND b.operation_sequence_id = fbor.operation_sequence_id
3806: AND a.created_by = b.schedule_seq_num

Line 3832: bom_resources c,

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
3836: AND fbor.revised_item_sequence_id = p_rev_item_seq_id

Line 3833: bom_resources d

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
3836: AND fbor.revised_item_sequence_id = p_rev_item_seq_id
3837: AND b.operation_sequence_id = fbor.operation_sequence_id

Line 3869: bom_resources c

3865: 2
3866: )
3867: )
3868: FROM mtl_units_of_measure b,
3869: bom_resources c
3870: WHERE a.resource_id = c.resource_id
3871: AND c.unit_of_measure = b.uom_code(+)), -- modified from b.unit_of_messure to b.uom_code for bug 10362130
3872: setup_id =
3873: (SELECT brs.setup_id