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.

[Home] [Help]

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 2188: ||' FND_GLOBAL.USER_ID,'

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

Line 2190: ||' FND_GLOBAL.USER_ID,'

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

Line 2377: ||' FND_GLOBAL.USER_ID,'

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

Line 2379: ||' FND_GLOBAL.USER_ID,'

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

Line 2583: ||' FND_GLOBAL.USER_ID,'

2579: ||' DELIVER_TO_LOCATION_ID,'
2580: ||' DELIVER_TO_REQUESTOR_ID,'
2581: ||' SUGGESTED_VENDOR_ID,'
2582: ||' SUGGESTED_VENDOR_SITE,'
2583: ||' FND_GLOBAL.USER_ID,'
2584: ||' SYSDATE,'
2585: ||' LAST_UPDATE_LOGIN,'
2586: ||' SYSDATE,'
2587: ||' FND_GLOBAL.USER_ID,'

Line 2587: ||' FND_GLOBAL.USER_ID,'

2583: ||' FND_GLOBAL.USER_ID,'
2584: ||' SYSDATE,'
2585: ||' LAST_UPDATE_LOGIN,'
2586: ||' SYSDATE,'
2587: ||' FND_GLOBAL.USER_ID,'
2588: ||' INTERFACE_SOURCE_CODE,'
2589: ||' SOURCE_TYPE_CODE,'
2590: ||' DESTINATION_TYPE_CODE,'
2591: ||' QUANTITY,'

Line 2846: ||' FND_GLOBAL.USER_ID,'

2842: ||' QUANTITY,'
2843: ||' NEED_BY_DATE,'
2844: ||' NULL,'
2845: ||' SYSDATE,'
2846: ||' FND_GLOBAL.USER_ID,'
2847: ||' SYSDATE,'
2848: ||' FND_GLOBAL.USER_ID,'
2849: ||' LAST_UPDATE_LOGIN,'
2850: ||' REQUEST_ID,'

Line 2848: ||' FND_GLOBAL.USER_ID,'

2844: ||' NULL,'
2845: ||' SYSDATE,'
2846: ||' FND_GLOBAL.USER_ID,'
2847: ||' SYSDATE,'
2848: ||' FND_GLOBAL.USER_ID,'
2849: ||' LAST_UPDATE_LOGIN,'
2850: ||' REQUEST_ID,'
2851: ||' PROGRAM_APPLICATION_ID,'
2852: ||' PROGRAM_ID,'

Line 3552: FND_GLOBAL.USER_ID,

3548: -- , resource_seq_num
3549: -- , schedule_seq_num
3550: )
3551: SELECT SYSDATE,
3552: FND_GLOBAL.USER_ID,
3553: FND_GLOBAL.USER_ID,
3554: SYSDATE,
3555: FND_GLOBAL.USER_ID,
3556: G_WIP_GROUP_ID,

Line 3553: FND_GLOBAL.USER_ID,

3549: -- , schedule_seq_num
3550: )
3551: SELECT SYSDATE,
3552: FND_GLOBAL.USER_ID,
3553: FND_GLOBAL.USER_ID,
3554: SYSDATE,
3555: FND_GLOBAL.USER_ID,
3556: G_WIP_GROUP_ID,
3557: lsud_header_id(j),

Line 3555: FND_GLOBAL.USER_ID,

3551: SELECT SYSDATE,
3552: FND_GLOBAL.USER_ID,
3553: FND_GLOBAL.USER_ID,
3554: SYSDATE,
3555: FND_GLOBAL.USER_ID,
3556: G_WIP_GROUP_ID,
3557: lsud_header_id(j),
3558: lsud_op_seq_num(j),
3559: lsud_res_seq(j),

Line 3704: FND_GLOBAL.USER_ID,

3700: process_phase,
3701: process_status,
3702: scheduled_flag)
3703: SELECT SYSDATE,
3704: FND_GLOBAL.USER_ID,
3705: FND_GLOBAL.USER_ID,
3706: SYSDATE,
3707: FND_GLOBAL.USER_ID,
3708: G_WIP_GROUP_ID,

Line 3705: FND_GLOBAL.USER_ID,

3701: process_status,
3702: scheduled_flag)
3703: SELECT SYSDATE,
3704: FND_GLOBAL.USER_ID,
3705: FND_GLOBAL.USER_ID,
3706: SYSDATE,
3707: FND_GLOBAL.USER_ID,
3708: G_WIP_GROUP_ID,
3709: lv_header_id(n),

Line 3707: FND_GLOBAL.USER_ID,

3703: SELECT SYSDATE,
3704: FND_GLOBAL.USER_ID,
3705: FND_GLOBAL.USER_ID,
3706: SYSDATE,
3707: FND_GLOBAL.USER_ID,
3708: G_WIP_GROUP_ID,
3709: lv_header_id(n),
3710: luno_op_seq_num(m),
3711: luno_std_op_seq_id(m),

Line 3962: FND_GLOBAL.USER_ID,

3958: process_phase,
3959: process_status,
3960: scheduled_flag)
3961: SELECT SYSDATE,
3962: FND_GLOBAL.USER_ID,
3963: FND_GLOBAL.USER_ID,
3964: SYSDATE,
3965: FND_GLOBAL.USER_ID,
3966: G_WIP_GROUP_ID,

Line 3963: FND_GLOBAL.USER_ID,

3959: process_status,
3960: scheduled_flag)
3961: SELECT SYSDATE,
3962: FND_GLOBAL.USER_ID,
3963: FND_GLOBAL.USER_ID,
3964: SYSDATE,
3965: FND_GLOBAL.USER_ID,
3966: G_WIP_GROUP_ID,
3967: lv_header_id(n),

Line 3965: FND_GLOBAL.USER_ID,

3961: SELECT SYSDATE,
3962: FND_GLOBAL.USER_ID,
3963: FND_GLOBAL.USER_ID,
3964: SYSDATE,
3965: FND_GLOBAL.USER_ID,
3966: G_WIP_GROUP_ID,
3967: lv_header_id(n),
3968: lun_op_seq_num(j),
3969: lun_res_seq(j),

Line 4133: FND_GLOBAL.USER_ID,

4129: process_phase,
4130: process_status,
4131: scheduled_flag)
4132: SELECT SYSDATE,
4133: FND_GLOBAL.USER_ID,
4134: FND_GLOBAL.USER_ID,
4135: SYSDATE,
4136: FND_GLOBAL.USER_ID,
4137: G_WIP_GROUP_ID,

Line 4134: FND_GLOBAL.USER_ID,

4130: process_status,
4131: scheduled_flag)
4132: SELECT SYSDATE,
4133: FND_GLOBAL.USER_ID,
4134: FND_GLOBAL.USER_ID,
4135: SYSDATE,
4136: FND_GLOBAL.USER_ID,
4137: G_WIP_GROUP_ID,
4138: lv_res_alt_hdr_id(j),

Line 4136: FND_GLOBAL.USER_ID,

4132: SELECT SYSDATE,
4133: FND_GLOBAL.USER_ID,
4134: FND_GLOBAL.USER_ID,
4135: SYSDATE,
4136: FND_GLOBAL.USER_ID,
4137: G_WIP_GROUP_ID,
4138: lv_res_alt_hdr_id(j),
4139: lv_res_alt_op_seq_num(j),
4140: lv_res_alt_res_seq_num(j),

Line 4289: ||' FND_GLOBAL.USER_ID,'

4285: ||' schedule_group_id,'
4286: ||' REBUILD_SERIAL_NUMBER )' -- build_sequence )'
4287: ||' SELECT'
4288: ||' SYSDATE,'
4289: ||' FND_GLOBAL.USER_ID,'
4290: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4291: ||' FND_GLOBAL.USER_ID,'
4292: ||' LAST_UPDATE_LOGIN,'
4293: ||' WIP_ENTITY_ID,'

Line 4291: ||' FND_GLOBAL.USER_ID,'

4287: ||' SELECT'
4288: ||' SYSDATE,'
4289: ||' FND_GLOBAL.USER_ID,'
4290: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4291: ||' FND_GLOBAL.USER_ID,'
4292: ||' LAST_UPDATE_LOGIN,'
4293: ||' WIP_ENTITY_ID,'
4294: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4295: ||' wip_entity_id,'

Line 4354: ||' FND_GLOBAL.USER_ID,'

4350: ||' START_DATE,'
4351: ||' COMPLETION_DATE )'
4352: ||' SELECT'
4353: ||' SYSDATE,'
4354: ||' FND_GLOBAL.USER_ID,'
4355: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4356: ||' FND_GLOBAL.USER_ID,'
4357: ||' LAST_UPDATE_LOGIN,'
4358: ||' WIP_ENTITY_ID,'

Line 4356: ||' FND_GLOBAL.USER_ID,'

4352: ||' SELECT'
4353: ||' SYSDATE,'
4354: ||' FND_GLOBAL.USER_ID,'
4355: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4356: ||' FND_GLOBAL.USER_ID,'
4357: ||' LAST_UPDATE_LOGIN,'
4358: ||' WIP_ENTITY_ID,'
4359: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4360: ||' wip_entity_id,'

Line 4465: ||' FND_GLOBAL.USER_ID,'

4461: ||' date_required,'
4462: ||' Required_quantity )'
4463: ||' SELECT'
4464: ||' SYSDATE,'
4465: ||' FND_GLOBAL.USER_ID,'
4466: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4467: ||' FND_GLOBAL.USER_ID,'
4468: ||' LAST_UPDATE_LOGIN,'
4469: ||' WIP_ENTITY_ID,'

Line 4467: ||' FND_GLOBAL.USER_ID,'

4463: ||' SELECT'
4464: ||' SYSDATE,'
4465: ||' FND_GLOBAL.USER_ID,'
4466: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4467: ||' FND_GLOBAL.USER_ID,'
4468: ||' LAST_UPDATE_LOGIN,'
4469: ||' WIP_ENTITY_ID,'
4470: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4471: ||' wip_entity_id,'

Line 4516: ||' FND_GLOBAL.USER_ID,'

4512: ||' completion_date, '
4513: ||' SERIAL_NUMBER ) '
4514: ||' SELECT'
4515: ||' SYSDATE,'
4516: ||' FND_GLOBAL.USER_ID,'
4517: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4518: ||' FND_GLOBAL.USER_ID,'
4519: ||' LAST_UPDATE_LOGIN,'
4520: ||' WIP_ENTITY_ID,'

Line 4518: ||' FND_GLOBAL.USER_ID,'

4514: ||' SELECT'
4515: ||' SYSDATE,'
4516: ||' FND_GLOBAL.USER_ID,'
4517: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4518: ||' FND_GLOBAL.USER_ID,'
4519: ||' LAST_UPDATE_LOGIN,'
4520: ||' WIP_ENTITY_ID,'
4521: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4522: ||' wip_entity_id,'

Line 4569: ||' FND_GLOBAL.USER_ID,'

4565: ||' completion_date, '
4566: ||' SERIAL_NUMBER ) '
4567: ||' SELECT'
4568: ||' SYSDATE,'
4569: ||' FND_GLOBAL.USER_ID,'
4570: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4571: ||' FND_GLOBAL.USER_ID,'
4572: ||' LAST_UPDATE_LOGIN,'
4573: ||' WIP_ENTITY_ID,'

Line 4571: ||' FND_GLOBAL.USER_ID,'

4567: ||' SELECT'
4568: ||' SYSDATE,'
4569: ||' FND_GLOBAL.USER_ID,'
4570: ||' DECODE( ORGANIZATION_TYPE,1,SYSDATE,creation_date), '
4571: ||' FND_GLOBAL.USER_ID,'
4572: ||' LAST_UPDATE_LOGIN,'
4573: ||' WIP_ENTITY_ID,'
4574: ||' EAM_WORK_ORDER_IMPORT_S.nextval,'
4575: ||' wip_entity_id,'