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 1545: bom_resources c,

1541: -- Add is the action for ECO
1542: b.original_system_reference
1543: FROM bom_operation_sequences a,
1544: bom_operation_resources b,
1545: bom_resources c,
1546: bom_resources d
1547: -- ,BOM_DEPARTMENT_RESOURCES E
1548: WHERE a.routing_sequence_id = to_sequence_id
1549: AND a.last_updated_by = b.operation_sequence_id

Line 1546: bom_resources d

1542: b.original_system_reference
1543: FROM bom_operation_sequences a,
1544: bom_operation_resources b,
1545: bom_resources c,
1546: bom_resources d
1547: -- ,BOM_DEPARTMENT_RESOURCES E
1548: WHERE a.routing_sequence_id = to_sequence_id
1549: AND a.last_updated_by = b.operation_sequence_id
1550: AND b.resource_id = c.resource_id

Line 1596: bom_resources c,

1592: sysdate
1593: FROM bom_operation_sequences a,
1594: bom_operation_resources b,
1595: bom_operation_sequences fbor,
1596: bom_resources c,
1597: bom_resources d
1598: WHERE a.routing_sequence_id = to_sequence_id
1599: AND a.last_updated_by = b.operation_sequence_id
1600: AND b.resource_id = c.resource_id

Line 1597: bom_resources d

1593: FROM bom_operation_sequences a,
1594: bom_operation_resources b,
1595: bom_operation_sequences fbor,
1596: bom_resources c,
1597: bom_resources d
1598: WHERE a.routing_sequence_id = to_sequence_id
1599: AND a.last_updated_by = b.operation_sequence_id
1600: AND b.resource_id = c.resource_id
1601: AND c.resource_code = d.resource_code(+)

Line 1626: bom_resources c,

1622: sysdate
1623: FROM bom_operation_sequences a,
1624: bom_operation_resources b,
1625: bom_operation_sequences fbor,
1626: bom_resources c,
1627: bom_resources d
1628: WHERE a.routing_sequence_id = to_sequence_id
1629: AND a.last_updated_by = b.operation_sequence_id
1630: AND b.resource_id = c.resource_id

Line 1627: bom_resources d

1623: FROM bom_operation_sequences a,
1624: bom_operation_resources b,
1625: bom_operation_sequences fbor,
1626: bom_resources c,
1627: bom_resources d
1628: WHERE a.routing_sequence_id = to_sequence_id
1629: AND a.last_updated_by = b.operation_sequence_id
1630: AND b.resource_id = c.resource_id
1631: AND c.resource_code = d.resource_code

Line 1670: bom_resources c

1666: 2
1667: )
1668: )
1669: FROM mtl_units_of_measure b,
1670: bom_resources c
1671: WHERE a.resource_id = c.resource_id
1672: AND c.unit_of_measure = b.unit_of_measure(+)),
1673: setup_id =
1674: (SELECT brs.setup_id

Line 1790: bom_resources c,

1786: b.original_system_reference
1787: FROM /*BOM_OPERATION_RESOURCES A, Commented for Bug 6828461*/
1788: bom_operation_sequences a, /*Added for Bug 6828461*/
1789: bom_sub_operation_resources b,
1790: bom_resources c,
1791: bom_resources d
1792: WHERE A.ROUTING_SEQUENCE_ID = to_sequence_id /*Added for performance improvement for bug 6828461*/
1793: AND a.last_updated_by = b.operation_sequence_id
1794: -- AND a.created_by = b.schedule_seq_num Bug No 6407518

Line 1791: bom_resources d

1787: FROM /*BOM_OPERATION_RESOURCES A, Commented for Bug 6828461*/
1788: bom_operation_sequences a, /*Added for Bug 6828461*/
1789: bom_sub_operation_resources b,
1790: bom_resources c,
1791: bom_resources d
1792: WHERE A.ROUTING_SEQUENCE_ID = to_sequence_id /*Added for performance improvement for bug 6828461*/
1793: AND a.last_updated_by = b.operation_sequence_id
1794: -- AND a.created_by = b.schedule_seq_num Bug No 6407518
1795: AND b.resource_id = c.resource_id

Line 1839: bom_resources c,

1835: sysdate
1836: FROM bom_operation_resources a,
1837: bom_operation_sequences fbor,
1838: bom_sub_operation_resources b,
1839: bom_resources c,
1840: bom_resources d
1841: WHERE a.last_updated_by = b.operation_sequence_id
1842: AND b.operation_sequence_id = fbor.operation_sequence_id
1843: AND a.created_by = b.schedule_seq_num

Line 1840: bom_resources d

1836: FROM bom_operation_resources a,
1837: bom_operation_sequences fbor,
1838: bom_sub_operation_resources b,
1839: bom_resources c,
1840: bom_resources d
1841: WHERE a.last_updated_by = b.operation_sequence_id
1842: AND b.operation_sequence_id = fbor.operation_sequence_id
1843: AND a.created_by = b.schedule_seq_num
1844: AND b.resource_id = c.resource_id

Line 1869: bom_resources c,

1865: sysdate
1866: FROM bom_operation_resources a,
1867: bom_operation_sequences fbor,
1868: bom_sub_operation_resources b,
1869: bom_resources c,
1870: bom_resources d
1871: WHERE a.last_updated_by = b.operation_sequence_id
1872: AND a.created_by = b.schedule_seq_num
1873: AND b.operation_sequence_id = fbor.operation_sequence_id

Line 1870: bom_resources d

1866: FROM bom_operation_resources a,
1867: bom_operation_sequences fbor,
1868: bom_sub_operation_resources b,
1869: bom_resources c,
1870: bom_resources d
1871: WHERE a.last_updated_by = b.operation_sequence_id
1872: AND a.created_by = b.schedule_seq_num
1873: AND b.operation_sequence_id = fbor.operation_sequence_id
1874: AND b.resource_id = c.resource_id

Line 1905: bom_resources c

1901: 2
1902: )
1903: )
1904: FROM mtl_units_of_measure b,
1905: bom_resources c
1906: WHERE a.resource_id = c.resource_id
1907: AND c.unit_of_measure = b.unit_of_measure(+)),
1908: setup_id =
1909: (SELECT brs.setup_id

Line 3374: bom_resources c,

3370: -- Add is the action for ECO
3371: b.original_system_reference
3372: FROM bom_operation_sequences a,
3373: bom_operation_resources b,
3374: bom_resources c,
3375: bom_resources d
3376: -- ,BOM_DEPARTMENT_RESOURCES E
3377: WHERE a.routing_sequence_id = to_sequence_id
3378: AND a.last_updated_by = b.operation_sequence_id

Line 3375: bom_resources d

3371: b.original_system_reference
3372: FROM bom_operation_sequences a,
3373: bom_operation_resources b,
3374: bom_resources c,
3375: bom_resources d
3376: -- ,BOM_DEPARTMENT_RESOURCES E
3377: WHERE a.routing_sequence_id = to_sequence_id
3378: AND a.last_updated_by = b.operation_sequence_id
3379: AND b.resource_id = c.resource_id

Line 3426: bom_resources c,

3422: sysdate
3423: FROM bom_operation_sequences a,
3424: bom_operation_resources b,
3425: bom_operation_sequences fbor,
3426: bom_resources c,
3427: bom_resources d
3428: WHERE a.routing_sequence_id = to_sequence_id
3429: AND a.last_updated_by = b.operation_sequence_id
3430: AND b.resource_id = c.resource_id

Line 3427: bom_resources d

3423: FROM bom_operation_sequences a,
3424: bom_operation_resources b,
3425: bom_operation_sequences fbor,
3426: bom_resources c,
3427: bom_resources d
3428: WHERE a.routing_sequence_id = to_sequence_id
3429: AND a.last_updated_by = b.operation_sequence_id
3430: AND b.resource_id = c.resource_id
3431: AND c.resource_code = d.resource_code(+)

Line 3457: bom_resources c,

3453: sysdate
3454: FROM bom_operation_sequences a,
3455: bom_operation_resources b,
3456: bom_operation_sequences fbor,
3457: bom_resources c,
3458: bom_resources d
3459: WHERE a.routing_sequence_id = to_sequence_id
3460: AND a.last_updated_by = b.operation_sequence_id
3461: AND b.resource_id = c.resource_id

Line 3458: bom_resources d

3454: FROM bom_operation_sequences a,
3455: bom_operation_resources b,
3456: bom_operation_sequences fbor,
3457: bom_resources c,
3458: bom_resources d
3459: WHERE a.routing_sequence_id = to_sequence_id
3460: AND a.last_updated_by = b.operation_sequence_id
3461: AND b.resource_id = c.resource_id
3462: AND c.resource_code = d.resource_code

Line 3502: bom_resources c

3498: 2
3499: )
3500: )
3501: FROM mtl_units_of_measure b,
3502: bom_resources c
3503: WHERE a.resource_id = c.resource_id
3504: AND c.unit_of_measure = b.unit_of_measure(+)),
3505: setup_id =
3506: (SELECT brs.setup_id

Line 3620: bom_resources c,

3616: -- Add is the action for ECO
3617: b.original_system_reference
3618: FROM bom_operation_resources a,
3619: bom_sub_operation_resources b,
3620: bom_resources c,
3621: bom_resources d,
3622: bom_operation_sequences bos
3623: WHERE a.last_updated_by = b.operation_sequence_id
3624: AND bos.operation_sequence_id = b.operation_sequence_id

Line 3621: bom_resources d,

3617: b.original_system_reference
3618: FROM bom_operation_resources a,
3619: bom_sub_operation_resources b,
3620: bom_resources c,
3621: bom_resources d,
3622: bom_operation_sequences bos
3623: WHERE a.last_updated_by = b.operation_sequence_id
3624: AND bos.operation_sequence_id = b.operation_sequence_id
3625: AND bos.revised_item_sequence_id = p_rev_item_seq_id

Line 3671: bom_resources c,

3667: sysdate
3668: FROM bom_operation_resources a,
3669: bom_operation_sequences fbor,
3670: bom_sub_operation_resources b,
3671: bom_resources c,
3672: bom_resources d
3673: WHERE a.last_updated_by = b.operation_sequence_id
3674: AND fbor.revised_item_sequence_id = p_rev_item_seq_id
3675: AND b.operation_sequence_id = fbor.operation_sequence_id

Line 3672: bom_resources d

3668: FROM bom_operation_resources a,
3669: bom_operation_sequences fbor,
3670: bom_sub_operation_resources b,
3671: bom_resources c,
3672: bom_resources d
3673: WHERE a.last_updated_by = b.operation_sequence_id
3674: AND fbor.revised_item_sequence_id = p_rev_item_seq_id
3675: AND b.operation_sequence_id = fbor.operation_sequence_id
3676: AND a.created_by = b.schedule_seq_num

Line 3702: bom_resources c,

3698: sysdate
3699: FROM bom_operation_resources a,
3700: bom_operation_sequences fbor,
3701: bom_sub_operation_resources b,
3702: bom_resources c,
3703: bom_resources d
3704: WHERE a.last_updated_by = b.operation_sequence_id
3705: AND a.created_by = b.schedule_seq_num
3706: AND fbor.revised_item_sequence_id = p_rev_item_seq_id

Line 3703: bom_resources d

3699: FROM bom_operation_resources a,
3700: bom_operation_sequences fbor,
3701: bom_sub_operation_resources b,
3702: bom_resources c,
3703: bom_resources d
3704: WHERE a.last_updated_by = b.operation_sequence_id
3705: AND a.created_by = b.schedule_seq_num
3706: AND fbor.revised_item_sequence_id = p_rev_item_seq_id
3707: AND b.operation_sequence_id = fbor.operation_sequence_id

Line 3739: bom_resources c

3735: 2
3736: )
3737: )
3738: FROM mtl_units_of_measure b,
3739: bom_resources c
3740: WHERE a.resource_id = c.resource_id
3741: AND c.unit_of_measure = b.unit_of_measure(+)),
3742: setup_id =
3743: (SELECT brs.setup_id