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 1692: INSERT INTO bom_sub_operation_resources

1688:
1689: -- Bug Fix 2991810
1690: sql_stmt_num := 25;
1691:
1692: INSERT INTO bom_sub_operation_resources
1693: (operation_sequence_id,
1694: substitute_group_num,
1695: resource_id,
1696: schedule_seq_num,

Line 1789: bom_sub_operation_resources b,

1785: -- Add is the action for ECO
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

Line 1838: bom_sub_operation_resources b,

1834: fnd_global.conc_program_id,
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

Line 1868: bom_sub_operation_resources b,

1864: fnd_global.conc_program_id,
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

Line 1890: UPDATE bom_sub_operation_resources a

1886: IF (from_org_id <> to_org_id)
1887: THEN
1888: sql_stmt_num := 35;
1889:
1890: UPDATE bom_sub_operation_resources a
1891: SET activity_id =
1892: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
1893: FROM cst_activities
1894: WHERE activity_id = a.activity_id),

Line 3524: INSERT INTO bom_sub_operation_resources

3520:
3521: -- Bug Fix 2991810
3522: sql_stmt_num := 25;
3523:
3524: INSERT INTO bom_sub_operation_resources
3525: (operation_sequence_id,
3526: substitute_group_num,
3527: resource_id,
3528: schedule_seq_num,

Line 3619: bom_sub_operation_resources b,

3615: DECODE (p_routing_or_eco, 1, b.acd_type, 1),
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

Line 3670: bom_sub_operation_resources b,

3666: fnd_global.conc_program_id,
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

Line 3701: bom_sub_operation_resources b,

3697: fnd_global.conc_program_id,
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

Line 3724: UPDATE bom_sub_operation_resources a

3720: IF (from_org_id <> to_org_id)
3721: THEN
3722: sql_stmt_num := 35;
3723:
3724: UPDATE bom_sub_operation_resources a
3725: SET activity_id =
3726: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
3727: FROM cst_activities
3728: WHERE activity_id = a.activity_id),