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.MRP_AP_REL_PLAN_PUB dependencies on FND_GLOBAL

Line 140: IF FND_GLOBAL.USER_ID = -1 THEN

136: p_po_batch_number := G_PO_BATCH_NUMBER;
137:
138: /* if user_id = -1, it means this procedure is called from a
139: remote database */
140: IF FND_GLOBAL.USER_ID = -1 THEN
141:
142: BEGIN
143:
144: SELECT USER_ID

Line 385: FND_GLOBAL.USER_ID,

381: process_phase,
382: process_status,
383: transaction_date)
384: SELECT SYSDATE,
385: FND_GLOBAL.USER_ID,
386: FND_GLOBAL.USER_ID,
387: SYSDATE,
388: FND_GLOBAL.USER_ID,
389: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 386: FND_GLOBAL.USER_ID,

382: process_status,
383: transaction_date)
384: SELECT SYSDATE,
385: FND_GLOBAL.USER_ID,
386: FND_GLOBAL.USER_ID,
387: SYSDATE,
388: FND_GLOBAL.USER_ID,
389: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
390: G_WIP_GROUP_ID,

Line 388: FND_GLOBAL.USER_ID,

384: SELECT SYSDATE,
385: FND_GLOBAL.USER_ID,
386: FND_GLOBAL.USER_ID,
387: SYSDATE,
388: FND_GLOBAL.USER_ID,
389: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
390: G_WIP_GROUP_ID,
391: lv_header_id(n),
392: lv_nwk_job_op_seq_num(j),

Line 677: FND_GLOBAL.USER_ID,

673: -- , resource_seq_num
674: -- , schedule_seq_num
675: )
676: SELECT SYSDATE,
677: FND_GLOBAL.USER_ID,
678: FND_GLOBAL.USER_ID,
679: SYSDATE,
680: FND_GLOBAL.USER_ID,
681: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 678: FND_GLOBAL.USER_ID,

674: -- , schedule_seq_num
675: )
676: SELECT SYSDATE,
677: FND_GLOBAL.USER_ID,
678: FND_GLOBAL.USER_ID,
679: SYSDATE,
680: FND_GLOBAL.USER_ID,
681: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
682: G_WIP_GROUP_ID,

Line 680: FND_GLOBAL.USER_ID,

676: SELECT SYSDATE,
677: FND_GLOBAL.USER_ID,
678: FND_GLOBAL.USER_ID,
679: SYSDATE,
680: FND_GLOBAL.USER_ID,
681: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
682: G_WIP_GROUP_ID,
683: lv_header_id(n),
684: lv_unschd_op_seq_num(l),

Line 769: FND_GLOBAL.USER_ID,

765: process_phase,
766: process_status,
767: transaction_date)
768: SELECT SYSDATE,
769: FND_GLOBAL.USER_ID,
770: FND_GLOBAL.USER_ID,
771: SYSDATE,
772: FND_GLOBAL.USER_ID,
773: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 770: FND_GLOBAL.USER_ID,

766: process_status,
767: transaction_date)
768: SELECT SYSDATE,
769: FND_GLOBAL.USER_ID,
770: FND_GLOBAL.USER_ID,
771: SYSDATE,
772: FND_GLOBAL.USER_ID,
773: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
774: G_WIP_GROUP_ID,

Line 772: FND_GLOBAL.USER_ID,

768: SELECT SYSDATE,
769: FND_GLOBAL.USER_ID,
770: FND_GLOBAL.USER_ID,
771: SYSDATE,
772: FND_GLOBAL.USER_ID,
773: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
774: G_WIP_GROUP_ID,
775: lv_header_id(n),
776: null,

Line 816: FND_GLOBAL.USER_ID,

812: process_phase,
813: process_status,
814: transaction_date)
815: SELECT SYSDATE,
816: FND_GLOBAL.USER_ID,
817: FND_GLOBAL.USER_ID,
818: SYSDATE,
819: FND_GLOBAL.USER_ID,
820: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 817: FND_GLOBAL.USER_ID,

813: process_status,
814: transaction_date)
815: SELECT SYSDATE,
816: FND_GLOBAL.USER_ID,
817: FND_GLOBAL.USER_ID,
818: SYSDATE,
819: FND_GLOBAL.USER_ID,
820: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
821: G_WIP_GROUP_ID,

Line 819: FND_GLOBAL.USER_ID,

815: SELECT SYSDATE,
816: FND_GLOBAL.USER_ID,
817: FND_GLOBAL.USER_ID,
818: SYSDATE,
819: FND_GLOBAL.USER_ID,
820: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
821: G_WIP_GROUP_ID,
822: lv_header_id(n),
823: null,

Line 1070: FND_GLOBAL.USER_ID,

1066: -- , resource_seq_num
1067: -- , schedule_seq_num
1068: )
1069: SELECT SYSDATE,
1070: FND_GLOBAL.USER_ID,
1071: FND_GLOBAL.USER_ID,
1072: SYSDATE,
1073: FND_GLOBAL.USER_ID,
1074: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 1071: FND_GLOBAL.USER_ID,

1067: -- , schedule_seq_num
1068: )
1069: SELECT SYSDATE,
1070: FND_GLOBAL.USER_ID,
1071: FND_GLOBAL.USER_ID,
1072: SYSDATE,
1073: FND_GLOBAL.USER_ID,
1074: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1075: G_WIP_GROUP_ID,

Line 1073: FND_GLOBAL.USER_ID,

1069: SELECT SYSDATE,
1070: FND_GLOBAL.USER_ID,
1071: FND_GLOBAL.USER_ID,
1072: SYSDATE,
1073: FND_GLOBAL.USER_ID,
1074: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1075: G_WIP_GROUP_ID,
1076: lv_header_id(n),
1077: lv_unschd_job_op_seq_num(l),

Line 1193: FND_GLOBAL.USER_ID,

1189: process_phase,
1190: process_status,
1191: transaction_date)
1192: SELECT SYSDATE,
1193: FND_GLOBAL.USER_ID,
1194: FND_GLOBAL.USER_ID,
1195: SYSDATE,
1196: FND_GLOBAL.USER_ID,
1197: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 1194: FND_GLOBAL.USER_ID,

1190: process_status,
1191: transaction_date)
1192: SELECT SYSDATE,
1193: FND_GLOBAL.USER_ID,
1194: FND_GLOBAL.USER_ID,
1195: SYSDATE,
1196: FND_GLOBAL.USER_ID,
1197: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1198: G_WIP_GROUP_ID,

Line 1196: FND_GLOBAL.USER_ID,

1192: SELECT SYSDATE,
1193: FND_GLOBAL.USER_ID,
1194: FND_GLOBAL.USER_ID,
1195: SYSDATE,
1196: FND_GLOBAL.USER_ID,
1197: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1198: G_WIP_GROUP_ID,
1199: lv_header_id(n),
1200: null,

Line 1275: FND_GLOBAL.USER_ID,

1271: process_phase,
1272: process_status,
1273: transaction_date)
1274: SELECT SYSDATE,
1275: FND_GLOBAL.USER_ID,
1276: FND_GLOBAL.USER_ID,
1277: SYSDATE,
1278: FND_GLOBAL.USER_ID,
1279: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 1276: FND_GLOBAL.USER_ID,

1272: process_status,
1273: transaction_date)
1274: SELECT SYSDATE,
1275: FND_GLOBAL.USER_ID,
1276: FND_GLOBAL.USER_ID,
1277: SYSDATE,
1278: FND_GLOBAL.USER_ID,
1279: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1280: G_WIP_GROUP_ID,

Line 1278: FND_GLOBAL.USER_ID,

1274: SELECT SYSDATE,
1275: FND_GLOBAL.USER_ID,
1276: FND_GLOBAL.USER_ID,
1277: SYSDATE,
1278: FND_GLOBAL.USER_ID,
1279: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1280: G_WIP_GROUP_ID,
1281: lv_header_id(n),
1282: lv_nwk_job_op_seq_num(k),

Line 1322: FND_GLOBAL.USER_ID,

1318: process_phase,
1319: process_status,
1320: transaction_date)
1321: SELECT SYSDATE,
1322: FND_GLOBAL.USER_ID,
1323: FND_GLOBAL.USER_ID,
1324: SYSDATE,
1325: FND_GLOBAL.USER_ID,
1326: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 1323: FND_GLOBAL.USER_ID,

1319: process_status,
1320: transaction_date)
1321: SELECT SYSDATE,
1322: FND_GLOBAL.USER_ID,
1323: FND_GLOBAL.USER_ID,
1324: SYSDATE,
1325: FND_GLOBAL.USER_ID,
1326: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1327: G_WIP_GROUP_ID,

Line 1325: FND_GLOBAL.USER_ID,

1321: SELECT SYSDATE,
1322: FND_GLOBAL.USER_ID,
1323: FND_GLOBAL.USER_ID,
1324: SYSDATE,
1325: FND_GLOBAL.USER_ID,
1326: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1327: G_WIP_GROUP_ID,
1328: lv_header_id(n),
1329: lv_nwk_job_op_seq_num(k),

Line 1417: FND_GLOBAL.USER_ID,

1413: process_phase,
1414: process_status,
1415: transaction_date)
1416: SELECT SYSDATE,
1417: FND_GLOBAL.USER_ID,
1418: FND_GLOBAL.USER_ID,
1419: SYSDATE,
1420: FND_GLOBAL.USER_ID,
1421: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 1418: FND_GLOBAL.USER_ID,

1414: process_status,
1415: transaction_date)
1416: SELECT SYSDATE,
1417: FND_GLOBAL.USER_ID,
1418: FND_GLOBAL.USER_ID,
1419: SYSDATE,
1420: FND_GLOBAL.USER_ID,
1421: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1422: G_WIP_GROUP_ID,

Line 1420: FND_GLOBAL.USER_ID,

1416: SELECT SYSDATE,
1417: FND_GLOBAL.USER_ID,
1418: FND_GLOBAL.USER_ID,
1419: SYSDATE,
1420: FND_GLOBAL.USER_ID,
1421: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1422: G_WIP_GROUP_ID,
1423: lv_header_id(n),
1424: lv_nwk_job_op_seq_num(k),

Line 1498: FND_GLOBAL.USER_ID,

1494: process_phase,
1495: process_status,
1496: transaction_date)
1497: SELECT SYSDATE,
1498: FND_GLOBAL.USER_ID,
1499: FND_GLOBAL.USER_ID,
1500: SYSDATE,
1501: FND_GLOBAL.USER_ID,
1502: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 1499: FND_GLOBAL.USER_ID,

1495: process_status,
1496: transaction_date)
1497: SELECT SYSDATE,
1498: FND_GLOBAL.USER_ID,
1499: FND_GLOBAL.USER_ID,
1500: SYSDATE,
1501: FND_GLOBAL.USER_ID,
1502: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1503: G_WIP_GROUP_ID,

Line 1501: FND_GLOBAL.USER_ID,

1497: SELECT SYSDATE,
1498: FND_GLOBAL.USER_ID,
1499: FND_GLOBAL.USER_ID,
1500: SYSDATE,
1501: FND_GLOBAL.USER_ID,
1502: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1503: G_WIP_GROUP_ID,
1504: lv_header_id(n),
1505: null,

Line 1544: FND_GLOBAL.USER_ID,

1540: process_phase,
1541: process_status,
1542: transaction_date)
1543: SELECT SYSDATE,
1544: FND_GLOBAL.USER_ID,
1545: FND_GLOBAL.USER_ID,
1546: SYSDATE,
1547: FND_GLOBAL.USER_ID,
1548: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 1545: FND_GLOBAL.USER_ID,

1541: process_status,
1542: transaction_date)
1543: SELECT SYSDATE,
1544: FND_GLOBAL.USER_ID,
1545: FND_GLOBAL.USER_ID,
1546: SYSDATE,
1547: FND_GLOBAL.USER_ID,
1548: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1549: G_WIP_GROUP_ID,

Line 1547: FND_GLOBAL.USER_ID,

1543: SELECT SYSDATE,
1544: FND_GLOBAL.USER_ID,
1545: FND_GLOBAL.USER_ID,
1546: SYSDATE,
1547: FND_GLOBAL.USER_ID,
1548: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1549: G_WIP_GROUP_ID,
1550: lv_header_id(n),
1551: null,

Line 1639: FND_GLOBAL.USER_ID,

1635: process_phase,
1636: process_status,
1637: transaction_date)
1638: SELECT SYSDATE,
1639: FND_GLOBAL.USER_ID,
1640: FND_GLOBAL.USER_ID,
1641: SYSDATE,
1642: FND_GLOBAL.USER_ID,
1643: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,

Line 1640: FND_GLOBAL.USER_ID,

1636: process_status,
1637: transaction_date)
1638: SELECT SYSDATE,
1639: FND_GLOBAL.USER_ID,
1640: FND_GLOBAL.USER_ID,
1641: SYSDATE,
1642: FND_GLOBAL.USER_ID,
1643: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1644: G_WIP_GROUP_ID,

Line 1642: FND_GLOBAL.USER_ID,

1638: SELECT SYSDATE,
1639: FND_GLOBAL.USER_ID,
1640: FND_GLOBAL.USER_ID,
1641: SYSDATE,
1642: FND_GLOBAL.USER_ID,
1643: WSM_LOT_SM_IFC_HEADER_S.NEXTVAL,
1644: G_WIP_GROUP_ID,
1645: lv_header_id(n),
1646: null,

Line 1886: ||' FND_GLOBAL.USER_ID,'

1882: ||' due_date)'
1883: ||' SELECT'
1884: ||' SYSDATE,'
1885: ||' 1,'
1886: ||' FND_GLOBAL.USER_ID,'
1887: ||' SYSDATE,'
1888: ||' FND_GLOBAL.USER_ID,'
1889: ||' LAST_UPDATE_LOGIN,'
1890: ||' DECODE( ORGANIZATION_TYPE,'

Line 1888: ||' FND_GLOBAL.USER_ID,'

1884: ||' SYSDATE,'
1885: ||' 1,'
1886: ||' FND_GLOBAL.USER_ID,'
1887: ||' SYSDATE,'
1888: ||' FND_GLOBAL.USER_ID,'
1889: ||' LAST_UPDATE_LOGIN,'
1890: ||' DECODE( ORGANIZATION_TYPE,'
1891: ||' 1,'||TO_CHAR(G_WIP_GROUP_ID)
1892: ||',2,'||TO_CHAR(G_OPM_WIP_GROUP_ID)||'),'

Line 2189: ||' FND_GLOBAL.USER_ID,'

2185: ||' priority, ' -- dsr
2186: ||' DUE_DATE)' ---- Need to check this was already there
2187: ||' SELECT'
2188: ||' SYSDATE,'
2189: ||' FND_GLOBAL.USER_ID,'
2190: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
2191: ||' FND_GLOBAL.USER_ID,'
2192: ||' LAST_UPDATE_LOGIN,'
2193: ||' DECODE( ORGANIZATION_TYPE,'

Line 2191: ||' FND_GLOBAL.USER_ID,'

2187: ||' SELECT'
2188: ||' SYSDATE,'
2189: ||' FND_GLOBAL.USER_ID,'
2190: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
2191: ||' FND_GLOBAL.USER_ID,'
2192: ||' LAST_UPDATE_LOGIN,'
2193: ||' DECODE( ORGANIZATION_TYPE,'
2194: ||' 1,'||TO_CHAR(G_WIP_GROUP_ID)
2195: ||',2,'||TO_CHAR(G_OPM_WIP_GROUP_ID)||'),'

Line 2378: ||' FND_GLOBAL.USER_ID,'

2374: ||' TRUNC(WIP_ENTITY_ID/2),' /* decode wip_entity_id */
2375: ||' ORGANIZATION_ID,'
2376: ||' decode(organization_type,2,fnd_number.number_to_canonical(resource_hours),resource_hours),'
2377: ||' SYSDATE,'
2378: ||' FND_GLOBAL.USER_ID,'
2379: ||' SYSDATE,'
2380: ||' FND_GLOBAL.USER_ID,'
2381: ||' LAST_UPDATE_LOGIN '
2382: -- dsr: added following 10 new columns

Line 2380: ||' FND_GLOBAL.USER_ID,'

2376: ||' decode(organization_type,2,fnd_number.number_to_canonical(resource_hours),resource_hours),'
2377: ||' SYSDATE,'
2378: ||' FND_GLOBAL.USER_ID,'
2379: ||' SYSDATE,'
2380: ||' FND_GLOBAL.USER_ID,'
2381: ||' LAST_UPDATE_LOGIN '
2382: -- dsr: added following 10 new columns
2383: ||' , serial_number '
2384: ||' , serial_number ' -- jguo

Line 2868: ||' FND_GLOBAL.USER_ID,'

2864: ||' DELIVER_TO_LOCATION_ID,'
2865: ||' DELIVER_TO_REQUESTOR_ID,'
2866: ||' SUGGESTED_VENDOR_ID,'
2867: ||' SUGGESTED_VENDOR_SITE,'
2868: ||' FND_GLOBAL.USER_ID,'
2869: ||' SYSDATE,'
2870: ||' LAST_UPDATE_LOGIN,'
2871: ||' SYSDATE,'
2872: ||' FND_GLOBAL.USER_ID,'

Line 2872: ||' FND_GLOBAL.USER_ID,'

2868: ||' FND_GLOBAL.USER_ID,'
2869: ||' SYSDATE,'
2870: ||' LAST_UPDATE_LOGIN,'
2871: ||' SYSDATE,'
2872: ||' FND_GLOBAL.USER_ID,'
2873: ||' INTERFACE_SOURCE_CODE,'
2874: ||' SOURCE_TYPE_CODE,'
2875: ||' DESTINATION_TYPE_CODE,'
2876: ||' QUANTITY,'

Line 3133: ||' FND_GLOBAL.USER_ID,'

3129: ||' QUANTITY,'
3130: ||' NEED_BY_DATE,'
3131: ||' NULL,'
3132: ||' SYSDATE,'
3133: ||' FND_GLOBAL.USER_ID,'
3134: ||' SYSDATE,'
3135: ||' FND_GLOBAL.USER_ID,'
3136: ||' LAST_UPDATE_LOGIN,'
3137: ||' REQUEST_ID,'

Line 3135: ||' FND_GLOBAL.USER_ID,'

3131: ||' NULL,'
3132: ||' SYSDATE,'
3133: ||' FND_GLOBAL.USER_ID,'
3134: ||' SYSDATE,'
3135: ||' FND_GLOBAL.USER_ID,'
3136: ||' LAST_UPDATE_LOGIN,'
3137: ||' REQUEST_ID,'
3138: ||' PROGRAM_APPLICATION_ID,'
3139: ||' PROGRAM_ID,'

Line 3841: FND_GLOBAL.USER_ID,

3837: -- , resource_seq_num
3838: -- , schedule_seq_num
3839: )
3840: SELECT SYSDATE,
3841: FND_GLOBAL.USER_ID,
3842: FND_GLOBAL.USER_ID,
3843: SYSDATE,
3844: FND_GLOBAL.USER_ID,
3845: G_WIP_GROUP_ID,

Line 3842: FND_GLOBAL.USER_ID,

3838: -- , schedule_seq_num
3839: )
3840: SELECT SYSDATE,
3841: FND_GLOBAL.USER_ID,
3842: FND_GLOBAL.USER_ID,
3843: SYSDATE,
3844: FND_GLOBAL.USER_ID,
3845: G_WIP_GROUP_ID,
3846: lsud_header_id(j),

Line 3844: FND_GLOBAL.USER_ID,

3840: SELECT SYSDATE,
3841: FND_GLOBAL.USER_ID,
3842: FND_GLOBAL.USER_ID,
3843: SYSDATE,
3844: FND_GLOBAL.USER_ID,
3845: G_WIP_GROUP_ID,
3846: lsud_header_id(j),
3847: lsud_op_seq_num(j),
3848: lsud_res_seq(j),

Line 3993: FND_GLOBAL.USER_ID,

3989: process_phase,
3990: process_status,
3991: scheduled_flag)
3992: SELECT SYSDATE,
3993: FND_GLOBAL.USER_ID,
3994: FND_GLOBAL.USER_ID,
3995: SYSDATE,
3996: FND_GLOBAL.USER_ID,
3997: G_WIP_GROUP_ID,

Line 3994: FND_GLOBAL.USER_ID,

3990: process_status,
3991: scheduled_flag)
3992: SELECT SYSDATE,
3993: FND_GLOBAL.USER_ID,
3994: FND_GLOBAL.USER_ID,
3995: SYSDATE,
3996: FND_GLOBAL.USER_ID,
3997: G_WIP_GROUP_ID,
3998: lv_header_id(n),

Line 3996: FND_GLOBAL.USER_ID,

3992: SELECT SYSDATE,
3993: FND_GLOBAL.USER_ID,
3994: FND_GLOBAL.USER_ID,
3995: SYSDATE,
3996: FND_GLOBAL.USER_ID,
3997: G_WIP_GROUP_ID,
3998: lv_header_id(n),
3999: luno_op_seq_num(m),
4000: luno_std_op_seq_id(m),

Line 4264: FND_GLOBAL.USER_ID,

4260: process_phase,
4261: process_status,
4262: scheduled_flag)
4263: SELECT SYSDATE,
4264: FND_GLOBAL.USER_ID,
4265: FND_GLOBAL.USER_ID,
4266: SYSDATE,
4267: FND_GLOBAL.USER_ID,
4268: G_WIP_GROUP_ID,

Line 4265: FND_GLOBAL.USER_ID,

4261: process_status,
4262: scheduled_flag)
4263: SELECT SYSDATE,
4264: FND_GLOBAL.USER_ID,
4265: FND_GLOBAL.USER_ID,
4266: SYSDATE,
4267: FND_GLOBAL.USER_ID,
4268: G_WIP_GROUP_ID,
4269: lv_header_id(n),

Line 4267: FND_GLOBAL.USER_ID,

4263: SELECT SYSDATE,
4264: FND_GLOBAL.USER_ID,
4265: FND_GLOBAL.USER_ID,
4266: SYSDATE,
4267: FND_GLOBAL.USER_ID,
4268: G_WIP_GROUP_ID,
4269: lv_header_id(n),
4270: lun_op_seq_num(j),
4271: lun_res_seq(j),

Line 4435: FND_GLOBAL.USER_ID,

4431: process_phase,
4432: process_status,
4433: scheduled_flag)
4434: SELECT SYSDATE,
4435: FND_GLOBAL.USER_ID,
4436: FND_GLOBAL.USER_ID,
4437: SYSDATE,
4438: FND_GLOBAL.USER_ID,
4439: G_WIP_GROUP_ID,

Line 4436: FND_GLOBAL.USER_ID,

4432: process_status,
4433: scheduled_flag)
4434: SELECT SYSDATE,
4435: FND_GLOBAL.USER_ID,
4436: FND_GLOBAL.USER_ID,
4437: SYSDATE,
4438: FND_GLOBAL.USER_ID,
4439: G_WIP_GROUP_ID,
4440: lv_res_alt_hdr_id(j),

Line 4438: FND_GLOBAL.USER_ID,

4434: SELECT SYSDATE,
4435: FND_GLOBAL.USER_ID,
4436: FND_GLOBAL.USER_ID,
4437: SYSDATE,
4438: FND_GLOBAL.USER_ID,
4439: G_WIP_GROUP_ID,
4440: lv_res_alt_hdr_id(j),
4441: lv_res_alt_op_seq_num(j),
4442: lv_res_alt_res_seq_num(j),

Line 4591: ||' FND_GLOBAL.USER_ID,'

4587: ||' schedule_group_id,'
4588: ||' REBUILD_SERIAL_NUMBER )' -- build_sequence )'
4589: ||' SELECT'
4590: ||' SYSDATE,'
4591: ||' FND_GLOBAL.USER_ID,'
4592: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4593: ||' FND_GLOBAL.USER_ID,'
4594: ||' LAST_UPDATE_LOGIN,'
4595: ||' WIP_ENTITY_ID,'

Line 4593: ||' FND_GLOBAL.USER_ID,'

4589: ||' SELECT'
4590: ||' SYSDATE,'
4591: ||' FND_GLOBAL.USER_ID,'
4592: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4593: ||' FND_GLOBAL.USER_ID,'
4594: ||' LAST_UPDATE_LOGIN,'
4595: ||' WIP_ENTITY_ID,'
4596: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4597: ||' wip_entity_id,'

Line 4656: ||' FND_GLOBAL.USER_ID,'

4652: ||' START_DATE,'
4653: ||' COMPLETION_DATE )'
4654: ||' SELECT'
4655: ||' SYSDATE,'
4656: ||' FND_GLOBAL.USER_ID,'
4657: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4658: ||' FND_GLOBAL.USER_ID,'
4659: ||' LAST_UPDATE_LOGIN,'
4660: ||' WIP_ENTITY_ID,'

Line 4658: ||' FND_GLOBAL.USER_ID,'

4654: ||' SELECT'
4655: ||' SYSDATE,'
4656: ||' FND_GLOBAL.USER_ID,'
4657: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4658: ||' FND_GLOBAL.USER_ID,'
4659: ||' LAST_UPDATE_LOGIN,'
4660: ||' WIP_ENTITY_ID,'
4661: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4662: ||' wip_entity_id,'

Line 4767: ||' FND_GLOBAL.USER_ID,'

4763: ||' date_required,'
4764: ||' Required_quantity )'
4765: ||' SELECT'
4766: ||' SYSDATE,'
4767: ||' FND_GLOBAL.USER_ID,'
4768: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4769: ||' FND_GLOBAL.USER_ID,'
4770: ||' LAST_UPDATE_LOGIN,'
4771: ||' WIP_ENTITY_ID,'

Line 4769: ||' FND_GLOBAL.USER_ID,'

4765: ||' SELECT'
4766: ||' SYSDATE,'
4767: ||' FND_GLOBAL.USER_ID,'
4768: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4769: ||' FND_GLOBAL.USER_ID,'
4770: ||' LAST_UPDATE_LOGIN,'
4771: ||' WIP_ENTITY_ID,'
4772: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4773: ||' wip_entity_id,'

Line 4818: ||' FND_GLOBAL.USER_ID,'

4814: ||' completion_date, '
4815: ||' SERIAL_NUMBER ) '
4816: ||' SELECT'
4817: ||' SYSDATE,'
4818: ||' FND_GLOBAL.USER_ID,'
4819: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4820: ||' FND_GLOBAL.USER_ID,'
4821: ||' LAST_UPDATE_LOGIN,'
4822: ||' WIP_ENTITY_ID,'

Line 4820: ||' FND_GLOBAL.USER_ID,'

4816: ||' SELECT'
4817: ||' SYSDATE,'
4818: ||' FND_GLOBAL.USER_ID,'
4819: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4820: ||' FND_GLOBAL.USER_ID,'
4821: ||' LAST_UPDATE_LOGIN,'
4822: ||' WIP_ENTITY_ID,'
4823: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4824: ||' wip_entity_id,'

Line 4871: ||' FND_GLOBAL.USER_ID,'

4867: ||' completion_date, '
4868: ||' SERIAL_NUMBER ) '
4869: ||' SELECT'
4870: ||' SYSDATE,'
4871: ||' FND_GLOBAL.USER_ID,'
4872: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4873: ||' FND_GLOBAL.USER_ID,'
4874: ||' LAST_UPDATE_LOGIN,'
4875: ||' WIP_ENTITY_ID,'

Line 4873: ||' FND_GLOBAL.USER_ID,'

4869: ||' SELECT'
4870: ||' SYSDATE,'
4871: ||' FND_GLOBAL.USER_ID,'
4872: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4873: ||' FND_GLOBAL.USER_ID,'
4874: ||' LAST_UPDATE_LOGIN,'
4875: ||' WIP_ENTITY_ID,'
4876: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4877: ||' wip_entity_id,'