[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
1499: --UPDATE RESOURCE_ID TO THAT OF COPY_TO_ORG
1500: --LEAVE OUT RESOURCES THAT DO NOT EXIST IN COPY_TO_ORG DEPT.
1501: sql_stmt_num := 20;
1502:
1503: INSERT INTO bom_operation_resources
1504: (operation_sequence_id,
1505: resource_seq_num,
1506: resource_id,
1507: activity_id,
1596: -- Add is the action for ECO
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
1646: NULL,
1647: fnd_global.conc_program_id,
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
1676: NULL,
1677: fnd_global.conc_program_id,
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
1707: IF (from_org_id <> to_org_id)
1708: THEN
1709: sql_stmt_num := 30;
1710:
1711: UPDATE bom_operation_resources a
1712: SET activity_id =
1713: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
1714: FROM cst_activities
1715: WHERE activity_id = a.activity_id),
1847: ),
1848: DECODE (p_routing_or_eco, 1, NULL, 1),
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
1896: fnd_global.conc_request_id,
1897: NULL,
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
1926: fnd_global.conc_request_id,
1927: NULL,
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
1996:
1997: -- Bug Fix 2991810
1998: sql_stmt_num := 65;
1999:
2000: UPDATE bom_operation_resources
2001: SET last_updated_by = user_id,
2002: created_by = user_id
2003: WHERE operation_sequence_id IN (
2004: SELECT operation_sequence_id
3391: --UPDATE RESOURCE_ID TO THAT OF COPY_TO_ORG
3392: --LEAVE OUT RESOURCES THAT DO NOT EXIST IN COPY_TO_ORG DEPT.
3393: sql_stmt_num := 20;
3394:
3395: INSERT INTO bom_operation_resources
3396: (operation_sequence_id,
3397: resource_seq_num,
3398: resource_id,
3399: activity_id,
3491: DECODE(p_routing_or_eco, 1, NULL, 1),
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
3542: NULL,
3543: fnd_global.conc_program_id,
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
3573: NULL,
3574: fnd_global.conc_program_id,
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
3605: IF (from_org_id <> to_org_id)
3606: THEN
3607: sql_stmt_num := 30;
3608:
3609: UPDATE bom_operation_resources a
3610: SET activity_id =
3611: (SELECT DECODE (organization_id, NULL, activity_id, NULL)
3612: FROM cst_activities
3613: WHERE activity_id = a.activity_id),
3744: DECODE(p_routing_or_eco, 1, NULL, 1),
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
3794: fnd_global.conc_request_id,
3795: NULL,
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
3825: fnd_global.conc_request_id,
3826: NULL,
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
3896:
3897: -- Bug Fix 2991810
3898: sql_stmt_num := 65;
3899:
3900: UPDATE bom_operation_resources
3901: SET last_updated_by = user_id,
3902: created_by = user_id
3903: WHERE operation_sequence_id IN (
3904: SELECT operation_sequence_id