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 FND_GLOBAL

Line 530: fnd_global.conc_request_id,

526: a.attribute12,
527: a.attribute13,
528: a.attribute14,
529: a.attribute15,
530: fnd_global.conc_request_id,
531: NULL,
532: fnd_global.conc_program_id,
533: sysdate,
534: a.operation_type,

Line 532: fnd_global.conc_program_id,

528: a.attribute14,
529: a.attribute15,
530: fnd_global.conc_request_id,
531: NULL,
532: fnd_global.conc_program_id,
533: sysdate,
534: a.operation_type,
535: DECODE (from_org_id, to_org_id, a.reference_flag, 2),
536: -- Bug 3473802

Line 675: fnd_global.conc_request_id,

671: user_id,
672: sysdate,
673: user_id,
674: 'E',
675: fnd_global.conc_request_id,
676: NULL,
677: fnd_global.conc_program_id,
678: sysdate
679: FROM bom_operation_sequences a, -- from op

Line 677: fnd_global.conc_program_id,

673: user_id,
674: 'E',
675: fnd_global.conc_request_id,
676: NULL,
677: fnd_global.conc_program_id,
678: sysdate
679: FROM bom_operation_sequences a, -- from op
680: bom_departments b, -- from op's dept
681: bom_departments c -- to op's dept

Line 743: fnd_global.conc_request_id,

739: user_id,
740: sysdate,
741: user_id,
742: 'E',
743: fnd_global.conc_request_id,
744: NULL,
745: fnd_global.conc_program_id,
746: sysdate
747: FROM bom_operation_sequences a, -- from op

Line 745: fnd_global.conc_program_id,

741: user_id,
742: 'E',
743: fnd_global.conc_request_id,
744: NULL,
745: fnd_global.conc_program_id,
746: sysdate
747: FROM bom_operation_sequences a, -- from op
748: bom_departments b, -- from op's dept
749: bom_departments c -- to op's dept

Line 827: fnd_global.conc_request_id,

823: user_id,
824: sysdate,
825: user_id,
826: 'E',
827: fnd_global.conc_request_id,
828: NULL,
829: fnd_global.conc_program_id,
830: sysdate
831: FROM bom_operation_sequences a

Line 829: fnd_global.conc_program_id,

825: user_id,
826: 'E',
827: fnd_global.conc_request_id,
828: NULL,
829: fnd_global.conc_program_id,
830: sysdate
831: FROM bom_operation_sequences a
832: WHERE a.routing_sequence_id = x_from_sequence_id
833: AND (display_option = 1 /* ALL */

Line 905: fnd_global.conc_request_id,

901: user_id,
902: sysdate,
903: user_id,
904: 'E',
905: fnd_global.conc_request_id,
906: NULL,
907: fnd_global.conc_program_id,
908: sysdate
909: FROM bom_operation_sequences a

Line 907: fnd_global.conc_program_id,

903: user_id,
904: 'E',
905: fnd_global.conc_request_id,
906: NULL,
907: fnd_global.conc_program_id,
908: sysdate
909: FROM bom_operation_sequences a
910: WHERE a.routing_sequence_id = x_from_sequence_id
911: AND (display_option = 1 /* ALL */

Line 1180: fnd_global.conc_request_id,

1176: bon.attribute12,
1177: bon.attribute13,
1178: bon.attribute14,
1179: bon.attribute15,
1180: fnd_global.conc_request_id,
1181: NULL,
1182: fnd_global.conc_program_id,
1183: sysdate
1184: FROM bom_operation_networks bon,

Line 1182: fnd_global.conc_program_id,

1178: bon.attribute14,
1179: bon.attribute15,
1180: fnd_global.conc_request_id,
1181: NULL,
1182: fnd_global.conc_program_id,
1183: sysdate
1184: FROM bom_operation_networks bon,
1185: bom_operation_sequences bos4, -- dest to op
1186: bom_operation_sequences bos3, -- dest from op

Line 1267: fnd_global.conc_request_id,

1263: user_id,
1264: sysdate,
1265: user_id,
1266: 'E',
1267: fnd_global.conc_request_id,
1268: NULL,
1269: fnd_global.conc_program_id,
1270: sysdate
1271: FROM bom_operation_networks bon,

Line 1269: fnd_global.conc_program_id,

1265: user_id,
1266: 'E',
1267: fnd_global.conc_request_id,
1268: NULL,
1269: fnd_global.conc_program_id,
1270: sysdate
1271: FROM bom_operation_networks bon,
1272: bom_operation_sequences bos4, -- dest to op
1273: bom_operation_sequences bos3, -- dest from op

Line 1309: fnd_global.conc_request_id,

1305: user_id,
1306: sysdate,
1307: user_id,
1308: 'E',
1309: fnd_global.conc_request_id,
1310: NULL,
1311: fnd_global.conc_program_id,
1312: sysdate
1313: FROM bom_operation_networks bon,

Line 1311: fnd_global.conc_program_id,

1307: user_id,
1308: 'E',
1309: fnd_global.conc_request_id,
1310: NULL,
1311: fnd_global.conc_program_id,
1312: sysdate
1313: FROM bom_operation_networks bon,
1314: bom_operation_sequences bos4, -- dest to op
1315: bom_operation_sequences bos3, -- dest from op

Line 1368: fnd_global.conc_request_id,

1364: user_id,
1365: sysdate,
1366: user_id,
1367: 'E',
1368: fnd_global.conc_request_id,
1369: NULL,
1370: fnd_global.conc_program_id,
1371: sysdate
1372: FROM bom_operation_networks bon,

Line 1370: fnd_global.conc_program_id,

1366: user_id,
1367: 'E',
1368: fnd_global.conc_request_id,
1369: NULL,
1370: fnd_global.conc_program_id,
1371: sysdate
1372: FROM bom_operation_networks bon,
1373: bom_operation_sequences bos4, -- dest to op
1374: bom_operation_sequences bos3, -- dest from op

Line 1410: fnd_global.conc_request_id,

1406: user_id,
1407: sysdate,
1408: user_id,
1409: 'E',
1410: fnd_global.conc_request_id,
1411: NULL,
1412: fnd_global.conc_program_id,
1413: sysdate
1414: FROM bom_operation_networks bon,

Line 1412: fnd_global.conc_program_id,

1408: user_id,
1409: 'E',
1410: fnd_global.conc_request_id,
1411: NULL,
1412: fnd_global.conc_program_id,
1413: sysdate
1414: FROM bom_operation_networks bon,
1415: bom_operation_sequences bos4, -- dest to op
1416: bom_operation_sequences bos3, -- dest from op

Line 1464: x_program_id => fnd_global.conc_program_id,

1460: x_to_pk5_value => '',
1461: x_created_by => user_id,
1462: x_last_update_login => '',
1463: x_program_application_id => '',
1464: x_program_id => fnd_global.conc_program_id,
1465: x_request_id => fnd_global.conc_request_id
1466: );
1467: sql_stmt_num := 301;
1468: END LOOP;

Line 1465: x_request_id => fnd_global.conc_request_id

1461: x_created_by => user_id,
1462: x_last_update_login => '',
1463: x_program_application_id => '',
1464: x_program_id => fnd_global.conc_program_id,
1465: x_request_id => fnd_global.conc_request_id
1466: );
1467: sql_stmt_num := 301;
1468: END LOOP;
1469:

Line 1491: x_program_id => fnd_global.conc_program_id,

1487: x_to_pk5_value => '',
1488: x_created_by => user_id,
1489: x_last_update_login => '',
1490: x_program_application_id => '',
1491: x_program_id => fnd_global.conc_program_id,
1492: x_request_id => fnd_global.conc_request_id
1493: );
1494: --end bug fix 3473851
1495:

Line 1492: x_request_id => fnd_global.conc_request_id

1488: x_created_by => user_id,
1489: x_last_update_login => '',
1490: x_program_application_id => '',
1491: x_program_id => fnd_global.conc_program_id,
1492: x_request_id => fnd_global.conc_request_id
1493: );
1494: --end bug fix 3473851
1495:
1496: --INSERT OPERATION RESOURCES

Line 1583: fnd_global.conc_request_id,

1579: b.attribute12,
1580: b.attribute13,
1581: b.attribute14,
1582: b.attribute15,
1583: fnd_global.conc_request_id,
1584: NULL,
1585: fnd_global.conc_program_id,
1586: sysdate,
1587: b.schedule_seq_num,

Line 1585: fnd_global.conc_program_id,

1581: b.attribute14,
1582: b.attribute15,
1583: fnd_global.conc_request_id,
1584: NULL,
1585: fnd_global.conc_program_id,
1586: sysdate,
1587: b.schedule_seq_num,
1588: b.substitute_group_num,
1589: b.principle_flag,

Line 1645: fnd_global.conc_request_id,

1641: user_id,
1642: sysdate,
1643: user_id,
1644: 'E',
1645: fnd_global.conc_request_id,
1646: NULL,
1647: fnd_global.conc_program_id,
1648: sysdate
1649: FROM bom_operation_sequences a,

Line 1647: fnd_global.conc_program_id,

1643: user_id,
1644: 'E',
1645: fnd_global.conc_request_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,

Line 1675: fnd_global.conc_request_id,

1671: user_id,
1672: sysdate,
1673: user_id,
1674: 'E',
1675: fnd_global.conc_request_id,
1676: NULL,
1677: fnd_global.conc_program_id,
1678: sysdate
1679: FROM bom_operation_sequences a,

Line 1677: fnd_global.conc_program_id,

1673: user_id,
1674: 'E',
1675: fnd_global.conc_request_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,

Line 1815: fnd_global.conc_request_id,

1811: NULL,
1812: b.resource_offset_percent,
1813: b.autocharge_type,
1814: b.attribute_category,
1815: fnd_global.conc_request_id,
1816: NULL,
1817: fnd_global.conc_program_id,
1818: sysdate,
1819: b.attribute1,

Line 1817: fnd_global.conc_program_id,

1813: b.autocharge_type,
1814: b.attribute_category,
1815: fnd_global.conc_request_id,
1816: NULL,
1817: fnd_global.conc_program_id,
1818: sysdate,
1819: b.attribute1,
1820: b.attribute2,
1821: b.attribute3,

Line 1896: fnd_global.conc_request_id,

1892: user_id,
1893: sysdate,
1894: user_id,
1895: 'E',
1896: fnd_global.conc_request_id,
1897: NULL,
1898: fnd_global.conc_program_id,
1899: sysdate
1900: FROM bom_operation_resources a,

Line 1898: fnd_global.conc_program_id,

1894: user_id,
1895: 'E',
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,

Line 1926: fnd_global.conc_request_id,

1922: user_id,
1923: sysdate,
1924: user_id,
1925: 'E',
1926: fnd_global.conc_request_id,
1927: NULL,
1928: fnd_global.conc_program_id,
1929: sysdate
1930: FROM bom_operation_resources a,

Line 1928: fnd_global.conc_program_id,

1924: user_id,
1925: 'E',
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,

Line 2580: fnd_global.conc_request_id,

2576: a.attribute12,
2577: a.attribute13,
2578: a.attribute14,
2579: a.attribute15,
2580: fnd_global.conc_request_id,
2581: NULL,
2582: fnd_global.conc_program_id,
2583: sysdate,
2584: a.operation_type,

Line 2582: fnd_global.conc_program_id,

2578: a.attribute14,
2579: a.attribute15,
2580: fnd_global.conc_request_id,
2581: NULL,
2582: fnd_global.conc_program_id,
2583: sysdate,
2584: a.operation_type,
2585: DECODE (from_org_id, to_org_id, a.reference_flag, 2),
2586: -- Bug 3473802

Line 2699: fnd_global.conc_request_id,

2695: user_id,
2696: sysdate,
2697: user_id,
2698: 'E',
2699: fnd_global.conc_request_id,
2700: NULL,
2701: fnd_global.conc_program_id,
2702: sysdate
2703: FROM bom_operation_sequences a, -- from op

Line 2701: fnd_global.conc_program_id,

2697: user_id,
2698: 'E',
2699: fnd_global.conc_request_id,
2700: NULL,
2701: fnd_global.conc_program_id,
2702: sysdate
2703: FROM bom_operation_sequences a, -- from op
2704: bom_departments b, -- from op's dept
2705: bom_departments c -- to op's dept

Line 2747: fnd_global.conc_request_id,

2743: user_id,
2744: sysdate,
2745: user_id,
2746: 'E',
2747: fnd_global.conc_request_id,
2748: NULL,
2749: fnd_global.conc_program_id,
2750: sysdate
2751: FROM bom_operation_sequences a, -- from op

Line 2749: fnd_global.conc_program_id,

2745: user_id,
2746: 'E',
2747: fnd_global.conc_request_id,
2748: NULL,
2749: fnd_global.conc_program_id,
2750: sysdate
2751: FROM bom_operation_sequences a, -- from op
2752: bom_departments b -- from op's dept
2753: WHERE a.routing_sequence_id = x_from_sequence_id

Line 2806: fnd_global.conc_request_id,

2802: user_id,
2803: sysdate,
2804: user_id,
2805: 'E',
2806: fnd_global.conc_request_id,
2807: NULL,
2808: fnd_global.conc_program_id,
2809: sysdate
2810: FROM bom_operation_sequences a

Line 2808: fnd_global.conc_program_id,

2804: user_id,
2805: 'E',
2806: fnd_global.conc_request_id,
2807: NULL,
2808: fnd_global.conc_program_id,
2809: sysdate
2810: FROM bom_operation_sequences a
2811: WHERE a.routing_sequence_id = x_from_sequence_id
2812: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date

Line 2865: fnd_global.conc_request_id,

2861: user_id,
2862: sysdate,
2863: user_id,
2864: 'E',
2865: fnd_global.conc_request_id,
2866: NULL,
2867: fnd_global.conc_program_id,
2868: sysdate
2869: FROM bom_operation_sequences a

Line 2867: fnd_global.conc_program_id,

2863: user_id,
2864: 'E',
2865: fnd_global.conc_request_id,
2866: NULL,
2867: fnd_global.conc_program_id,
2868: sysdate
2869: FROM bom_operation_sequences a
2870: WHERE a.routing_sequence_id = x_from_sequence_id
2871: AND ( ( p_cpy_disable_fields = 'Y' AND a.effectivity_date <= rev_date) -- For first revised item we can have past eff comps as eff on the target date

Line 3120: fnd_global.conc_request_id,

3116: bon.attribute12,
3117: bon.attribute13,
3118: bon.attribute14,
3119: bon.attribute15,
3120: fnd_global.conc_request_id,
3121: NULL,
3122: fnd_global.conc_program_id,
3123: sysdate
3124: FROM bom_operation_networks bon,

Line 3122: fnd_global.conc_program_id,

3118: bon.attribute14,
3119: bon.attribute15,
3120: fnd_global.conc_request_id,
3121: NULL,
3122: fnd_global.conc_program_id,
3123: sysdate
3124: FROM bom_operation_networks bon,
3125: bom_operation_sequences bos4, -- dest to op
3126: bom_operation_sequences bos3, -- dest from op

Line 3208: fnd_global.conc_request_id,

3204: user_id,
3205: sysdate,
3206: user_id,
3207: 'E',
3208: fnd_global.conc_request_id,
3209: NULL,
3210: fnd_global.conc_program_id,
3211: sysdate
3212: FROM bom_operation_networks bon,

Line 3210: fnd_global.conc_program_id,

3206: user_id,
3207: 'E',
3208: fnd_global.conc_request_id,
3209: NULL,
3210: fnd_global.conc_program_id,
3211: sysdate
3212: FROM bom_operation_networks bon,
3213: bom_operation_sequences bos4, -- dest to op
3214: bom_operation_sequences bos3, -- dest from op

Line 3251: fnd_global.conc_request_id,

3247: user_id,
3248: sysdate,
3249: user_id,
3250: 'E',
3251: fnd_global.conc_request_id,
3252: NULL,
3253: fnd_global.conc_program_id,
3254: sysdate
3255: FROM bom_operation_networks bon,

Line 3253: fnd_global.conc_program_id,

3249: user_id,
3250: 'E',
3251: fnd_global.conc_request_id,
3252: NULL,
3253: fnd_global.conc_program_id,
3254: sysdate
3255: FROM bom_operation_networks bon,
3256: bom_operation_sequences bos4, -- dest to op
3257: bom_operation_sequences bos3, -- dest from op

Line 3311: fnd_global.conc_request_id,

3307: user_id,
3308: sysdate,
3309: user_id,
3310: 'E',
3311: fnd_global.conc_request_id,
3312: NULL,
3313: fnd_global.conc_program_id,
3314: sysdate
3315: FROM bom_operation_networks bon,

Line 3313: fnd_global.conc_program_id,

3309: user_id,
3310: 'E',
3311: fnd_global.conc_request_id,
3312: NULL,
3313: fnd_global.conc_program_id,
3314: sysdate
3315: FROM bom_operation_networks bon,
3316: bom_operation_sequences bos4, -- dest to op
3317: bom_operation_sequences bos3, -- dest from op

Line 3354: fnd_global.conc_request_id,

3350: user_id,
3351: sysdate,
3352: user_id,
3353: 'E',
3354: fnd_global.conc_request_id,
3355: NULL,
3356: fnd_global.conc_program_id,
3357: sysdate
3358: FROM bom_operation_networks bon,

Line 3356: fnd_global.conc_program_id,

3352: user_id,
3353: 'E',
3354: fnd_global.conc_request_id,
3355: NULL,
3356: fnd_global.conc_program_id,
3357: sysdate
3358: FROM bom_operation_networks bon,
3359: bom_operation_sequences bos4, -- dest to op
3360: bom_operation_sequences bos3, -- dest from op

Line 3475: fnd_global.conc_request_id,

3471: b.attribute12,
3472: b.attribute13,
3473: b.attribute14,
3474: b.attribute15,
3475: fnd_global.conc_request_id,
3476: NULL,
3477: fnd_global.conc_program_id,
3478: sysdate,
3479: b.schedule_seq_num,

Line 3477: fnd_global.conc_program_id,

3473: b.attribute14,
3474: b.attribute15,
3475: fnd_global.conc_request_id,
3476: NULL,
3477: fnd_global.conc_program_id,
3478: sysdate,
3479: b.schedule_seq_num,
3480: b.substitute_group_num,
3481: b.principle_flag,

Line 3541: fnd_global.conc_request_id,

3537: user_id,
3538: sysdate,
3539: user_id,
3540: 'E',
3541: fnd_global.conc_request_id,
3542: NULL,
3543: fnd_global.conc_program_id,
3544: sysdate
3545: FROM bom_operation_sequences a,

Line 3543: fnd_global.conc_program_id,

3539: user_id,
3540: 'E',
3541: fnd_global.conc_request_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,

Line 3572: fnd_global.conc_request_id,

3568: user_id,
3569: sysdate,
3570: user_id,
3571: 'E',
3572: fnd_global.conc_request_id,
3573: NULL,
3574: fnd_global.conc_program_id,
3575: sysdate
3576: FROM bom_operation_sequences a,

Line 3574: fnd_global.conc_program_id,

3570: user_id,
3571: 'E',
3572: fnd_global.conc_request_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,

Line 3712: fnd_global.conc_request_id,

3708: NULL,
3709: b.resource_offset_percent,
3710: b.autocharge_type,
3711: b.attribute_category,
3712: fnd_global.conc_request_id,
3713: NULL,
3714: fnd_global.conc_program_id,
3715: sysdate,
3716: b.attribute1,

Line 3714: fnd_global.conc_program_id,

3710: b.autocharge_type,
3711: b.attribute_category,
3712: fnd_global.conc_request_id,
3713: NULL,
3714: fnd_global.conc_program_id,
3715: sysdate,
3716: b.attribute1,
3717: b.attribute2,
3718: b.attribute3,

Line 3794: fnd_global.conc_request_id,

3790: user_id,
3791: sysdate,
3792: user_id,
3793: 'E',
3794: fnd_global.conc_request_id,
3795: NULL,
3796: fnd_global.conc_program_id,
3797: sysdate
3798: FROM bom_operation_resources a,

Line 3796: fnd_global.conc_program_id,

3792: user_id,
3793: 'E',
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,

Line 3825: fnd_global.conc_request_id,

3821: user_id,
3822: sysdate,
3823: user_id,
3824: 'E',
3825: fnd_global.conc_request_id,
3826: NULL,
3827: fnd_global.conc_program_id,
3828: sysdate
3829: FROM bom_operation_resources a,

Line 3827: fnd_global.conc_program_id,

3823: user_id,
3824: 'E',
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,

Line 3994: x_program_id => fnd_global.conc_program_id,

3990: x_to_pk5_value => '',
3991: x_created_by => p_user_id,
3992: x_last_update_login => '',
3993: x_program_application_id => '',
3994: x_program_id => fnd_global.conc_program_id,
3995: x_request_id => fnd_global.conc_request_id
3996: );
3997: END LOOP;
3998:

Line 3995: x_request_id => fnd_global.conc_request_id

3991: x_created_by => p_user_id,
3992: x_last_update_login => '',
3993: x_program_application_id => '',
3994: x_program_id => fnd_global.conc_program_id,
3995: x_request_id => fnd_global.conc_request_id
3996: );
3997: END LOOP;
3998:
3999: END;

Line 4018: x_program_id => fnd_global.conc_program_id,

4014: x_to_pk5_value => '',
4015: x_created_by => p_user_id,
4016: x_last_update_login => '',
4017: x_program_application_id => '',
4018: x_program_id => fnd_global.conc_program_id,
4019: x_request_id => fnd_global.conc_request_id
4020: );
4021: --end bug fix 3473851
4022: END copy_attachments;

Line 4019: x_request_id => fnd_global.conc_request_id

4015: x_created_by => p_user_id,
4016: x_last_update_login => '',
4017: x_program_application_id => '',
4018: x_program_id => fnd_global.conc_program_id,
4019: x_request_id => fnd_global.conc_request_id
4020: );
4021: --end bug fix 3473851
4022: END copy_attachments;
4023: