[Home] [Help]
71:
72: SELECT COUNT (*)
73: INTO total_resources
74: FROM bom_operation_sequences a,
75: bom_operation_resources b
76: WHERE a.routing_sequence_id = from_rtg_seq_id
77: AND NVL (a.eco_for_production, 2) = 2
78: AND (display_option = 1
79: OR (display_option = 2
96:
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
1447: --UPDATE RESOURCE_ID TO THAT OF COPY_TO_ORG
1448: --LEAVE OUT RESOURCES THAT DO NOT EXIST IN COPY_TO_ORG DEPT.
1449: sql_stmt_num := 20;
1450:
1451: INSERT INTO bom_operation_resources
1452: (operation_sequence_id,
1453: resource_seq_num,
1454: resource_id,
1455: activity_id,
1540: DECODE (p_routing_or_eco, 1, b.acd_type, 1),
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
1590: NULL,
1591: fnd_global.conc_program_id,
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
1620: NULL,
1621: fnd_global.conc_program_id,
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
1651: IF (from_org_id <> to_org_id)
1652: THEN
1653: sql_stmt_num := 30;
1654:
1655: UPDATE bom_operation_resources a
1656: SET activity_id =
1657: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
1658: FROM cst_activities
1659: WHERE activity_id = a.activity_id),
1783: ),
1784: DECODE (p_routing_or_eco, 1, b.acd_type, 1),
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
1832: fnd_global.conc_request_id,
1833: NULL,
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
1862: fnd_global.conc_request_id,
1863: NULL,
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
1932:
1933: -- Bug Fix 2991810
1934: sql_stmt_num := 65;
1935:
1936: UPDATE bom_operation_resources
1937: SET last_updated_by = user_id,
1938: created_by = user_id
1939: WHERE operation_sequence_id IN (
1940: SELECT operation_sequence_id
3276: --UPDATE RESOURCE_ID TO THAT OF COPY_TO_ORG
3277: --LEAVE OUT RESOURCES THAT DO NOT EXIST IN COPY_TO_ORG DEPT.
3278: sql_stmt_num := 20;
3279:
3280: INSERT INTO bom_operation_resources
3281: (operation_sequence_id,
3282: resource_seq_num,
3283: resource_id,
3284: activity_id,
3369: DECODE (p_routing_or_eco, 1, b.acd_type, 1),
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
3420: NULL,
3421: fnd_global.conc_program_id,
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
3451: NULL,
3452: fnd_global.conc_program_id,
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
3483: IF (from_org_id <> to_org_id)
3484: THEN
3485: sql_stmt_num := 30;
3486:
3487: UPDATE bom_operation_resources a
3488: SET activity_id =
3489: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
3490: FROM cst_activities
3491: WHERE activity_id = a.activity_id),
3614: ),
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
3664: fnd_global.conc_request_id,
3665: NULL,
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
3695: fnd_global.conc_request_id,
3696: NULL,
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
3766:
3767: -- Bug Fix 2991810
3768: sql_stmt_num := 65;
3769:
3770: UPDATE bom_operation_resources
3771: SET last_updated_by = user_id,
3772: created_by = user_id
3773: WHERE operation_sequence_id IN (
3774: SELECT operation_sequence_id