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.JTF_TERR_SERVICE_PUB dependencies on DUAL

Line 192: FROM DUAL

188: ( SELECT 'COUNTRY' attribute_name
189: ,null num_value
190: ,p_TerrServReq_Rec.COUNTRY char_value
191: ,null date_value
192: FROM DUAL
193: UNION ALL
194: SELECT 'CITY' attribute_name
195: ,null num_value
196: ,upper(p_TerrServReq_Rec.CITY) char_value

Line 198: FROM DUAL

194: SELECT 'CITY' attribute_name
195: ,null num_value
196: ,upper(p_TerrServReq_Rec.CITY) char_value
197: ,null date_value
198: FROM DUAL
199: UNION ALL
200: SELECT 'POSTAL_CODE' attribute_name
201: ,null num_value
202: ,p_TerrServReq_Rec.POSTAL_CODE char_value

Line 204: FROM DUAL

200: SELECT 'POSTAL_CODE' attribute_name
201: ,null num_value
202: ,p_TerrServReq_Rec.POSTAL_CODE char_value
203: ,null date_value
204: FROM DUAL
205: UNION ALL
206: SELECT 'STATE' attribute_name
207: ,null num_value
208: ,p_TerrServReq_Rec.STATE char_value

Line 210: FROM DUAL

206: SELECT 'STATE' attribute_name
207: ,null num_value
208: ,p_TerrServReq_Rec.STATE char_value
209: ,null date_value
210: FROM DUAL
211: UNION ALL
212: SELECT 'AREA_CODE' attribute_name
213: ,null num_value
214: ,p_TerrServReq_Rec.AREA_CODE char_value

Line 216: FROM DUAL

212: SELECT 'AREA_CODE' attribute_name
213: ,null num_value
214: ,p_TerrServReq_Rec.AREA_CODE char_value
215: ,null date_value
216: FROM DUAL
217: UNION ALL
218: SELECT 'COUNTY' attribute_name
219: ,null num_value
220: ,p_TerrServReq_Rec.COUNTY char_value

Line 222: FROM DUAL

218: SELECT 'COUNTY' attribute_name
219: ,null num_value
220: ,p_TerrServReq_Rec.COUNTY char_value
221: ,null date_value
222: FROM DUAL
223: UNION ALL
224: SELECT 'COMP_NAME_RANGE' attribute_name
225: ,null num_value
226: ,p_TerrServReq_Rec.COMP_NAME_RANGE char_value

Line 228: FROM DUAL

224: SELECT 'COMP_NAME_RANGE' attribute_name
225: ,null num_value
226: ,p_TerrServReq_Rec.COMP_NAME_RANGE char_value
227: ,null date_value
228: FROM DUAL
229: UNION ALL
230: SELECT 'PROVINCE' attribute_name
231: ,null num_value
232: ,p_TerrServReq_Rec.PROVINCE char_value

Line 234: FROM DUAL

230: SELECT 'PROVINCE' attribute_name
231: ,null num_value
232: ,p_TerrServReq_Rec.PROVINCE char_value
233: ,null date_value
234: FROM DUAL
235: UNION ALL
236: SELECT 'PROBLEM_CODE' attribute_name
237: ,null num_value
238: ,p_TerrServReq_Rec.PROBLEM_CODE char_value

Line 240: FROM DUAL

236: SELECT 'PROBLEM_CODE' attribute_name
237: ,null num_value
238: ,p_TerrServReq_Rec.PROBLEM_CODE char_value
239: ,null date_value
240: FROM DUAL
241: UNION ALL
242: SELECT 'SR_CREATION_CHANNEL' attribute_name
243: ,null num_value
244: ,p_TerrServReq_Rec.SR_CREATION_CHANNEL char_value

Line 246: FROM DUAL

242: SELECT 'SR_CREATION_CHANNEL' attribute_name
243: ,null num_value
244: ,p_TerrServReq_Rec.SR_CREATION_CHANNEL char_value
245: ,null date_value
246: FROM DUAL
247: UNION ALL
248: SELECT 'VIP_CUSTOMER' attribute_name
249: ,null num_value
250: ,p_TerrServReq_Rec.squal_char11 char_value

Line 252: FROM DUAL

248: SELECT 'VIP_CUSTOMER' attribute_name
249: ,null num_value
250: ,p_TerrServReq_Rec.squal_char11 char_value
251: ,null date_value
252: FROM DUAL
253: UNION ALL
254: SELECT 'SR_PROBLEM_CODE' attribute_name
255: ,null num_value
256: ,p_TerrServReq_Rec.squal_char12 char_value

Line 258: FROM DUAL

254: SELECT 'SR_PROBLEM_CODE' attribute_name
255: ,null num_value
256: ,p_TerrServReq_Rec.squal_char12 char_value
257: ,null date_value
258: FROM DUAL
259: UNION ALL
260: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
261: ,null num_value
262: ,p_TerrServReq_Rec.squal_char13 char_value

Line 264: FROM DUAL

260: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
261: ,null num_value
262: ,p_TerrServReq_Rec.squal_char13 char_value
263: ,null date_value
264: FROM DUAL
265: UNION ALL
266: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
267: ,null num_value
268: ,p_TerrServReq_Rec.squal_char21 char_value

Line 270: FROM DUAL

266: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
267: ,null num_value
268: ,p_TerrServReq_Rec.squal_char21 char_value
269: ,null date_value
270: FROM DUAL
271: UNION ALL
272: SELECT 'SR_LANGUAGE' attribute_name
273: ,null num_value
274: ,p_TerrServReq_Rec.squal_char20 char_value

Line 276: FROM DUAL

272: SELECT 'SR_LANGUAGE' attribute_name
273: ,null num_value
274: ,p_TerrServReq_Rec.squal_char20 char_value
275: ,null date_value
276: FROM DUAL
277: UNION ALL
278: SELECT 'PARTY_ID' attribute_name
279: ,p_TerrServReq_Rec.PARTY_ID num_value
280: ,null char_value

Line 282: FROM DUAL

278: SELECT 'PARTY_ID' attribute_name
279: ,p_TerrServReq_Rec.PARTY_ID num_value
280: ,null char_value
281: ,null date_value
282: FROM DUAL
283: UNION ALL
284: SELECT 'PARTY_SITE_ID' attribute_name
285: ,p_TerrServReq_Rec.PARTY_SITE_ID num_value
286: ,null char_value

Line 288: FROM DUAL

284: SELECT 'PARTY_SITE_ID' attribute_name
285: ,p_TerrServReq_Rec.PARTY_SITE_ID num_value
286: ,null char_value
287: ,null date_value
288: FROM DUAL
289: UNION ALL
290: SELECT 'NUM_OF_EMPLOYEES' attribute_name
291: ,p_TerrServReq_Rec.NUM_OF_EMPLOYEES num_value
292: ,null char_value

Line 294: FROM DUAL

290: SELECT 'NUM_OF_EMPLOYEES' attribute_name
291: ,p_TerrServReq_Rec.NUM_OF_EMPLOYEES num_value
292: ,null char_value
293: ,null date_value
294: FROM DUAL
295: UNION ALL
296: SELECT 'INCIDENT_TYPE_ID' attribute_name
297: ,p_TerrServReq_Rec.INCIDENT_TYPE_ID num_value
298: ,null char_value

Line 300: FROM DUAL

296: SELECT 'INCIDENT_TYPE_ID' attribute_name
297: ,p_TerrServReq_Rec.INCIDENT_TYPE_ID num_value
298: ,null char_value
299: ,null date_value
300: FROM DUAL
301: UNION ALL
302: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
303: ,p_TerrServReq_Rec.INCIDENT_SEVERITY_ID num_value
304: ,null char_value

Line 306: FROM DUAL

302: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
303: ,p_TerrServReq_Rec.INCIDENT_SEVERITY_ID num_value
304: ,null char_value
305: ,null date_value
306: FROM DUAL
307: UNION ALL
308: SELECT 'INCIDENT_URGENCY_ID' attribute_name
309: ,p_TerrServReq_Rec.INCIDENT_URGENCY_ID num_value
310: ,null char_value

Line 312: FROM DUAL

308: SELECT 'INCIDENT_URGENCY_ID' attribute_name
309: ,p_TerrServReq_Rec.INCIDENT_URGENCY_ID num_value
310: ,null char_value
311: ,null date_value
312: FROM DUAL
313: UNION ALL
314: SELECT 'INCIDENT_STATUS_ID' attribute_name
315: ,p_TerrServReq_Rec.INCIDENT_STATUS_ID num_value
316: ,null char_value

Line 318: FROM DUAL

314: SELECT 'INCIDENT_STATUS_ID' attribute_name
315: ,p_TerrServReq_Rec.INCIDENT_STATUS_ID num_value
316: ,null char_value
317: ,null date_value
318: FROM DUAL
319: UNION ALL
320: SELECT 'PLATFORM_ID' attribute_name
321: ,p_TerrServReq_Rec.PLATFORM_ID num_value
322: ,null char_value

Line 324: FROM DUAL

320: SELECT 'PLATFORM_ID' attribute_name
321: ,p_TerrServReq_Rec.PLATFORM_ID num_value
322: ,null char_value
323: ,null date_value
324: FROM DUAL
325: UNION ALL
326: SELECT 'SUPPORT_SITE_ID' attribute_name
327: ,p_TerrServReq_Rec.SUPPORT_SITE_ID num_value
328: ,null char_value

Line 330: FROM DUAL

326: SELECT 'SUPPORT_SITE_ID' attribute_name
327: ,p_TerrServReq_Rec.SUPPORT_SITE_ID num_value
328: ,null char_value
329: ,null date_value
330: FROM DUAL
331: UNION ALL
332: SELECT 'CUSTOMER_SITE_ID' attribute_name
333: ,p_TerrServReq_Rec.CUSTOMER_SITE_ID num_value
334: ,null char_value

Line 336: FROM DUAL

332: SELECT 'CUSTOMER_SITE_ID' attribute_name
333: ,p_TerrServReq_Rec.CUSTOMER_SITE_ID num_value
334: ,null char_value
335: ,null date_value
336: FROM DUAL
337: UNION ALL
338: SELECT 'INVENTORY_ITEM_ID' attribute_name
339: ,p_TerrServReq_Rec.INVENTORY_ITEM_ID num_value
340: ,null char_value

Line 342: FROM DUAL

338: SELECT 'INVENTORY_ITEM_ID' attribute_name
339: ,p_TerrServReq_Rec.INVENTORY_ITEM_ID num_value
340: ,null char_value
341: ,null date_value
342: FROM DUAL
343: UNION ALL
344: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
345: ,p_TerrServReq_Rec.SQUAL_NUM12 num_value
346: ,null char_value

Line 348: FROM DUAL

344: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
345: ,p_TerrServReq_Rec.SQUAL_NUM12 num_value
346: ,null char_value
347: ,null date_value
348: FROM DUAL
349: UNION ALL
350: SELECT 'SRP_ORG_ID' attribute_name
351: ,p_TerrServReq_Rec.SQUAL_NUM13 num_value
352: ,null char_value

Line 354: FROM DUAL

350: SELECT 'SRP_ORG_ID' attribute_name
351: ,p_TerrServReq_Rec.SQUAL_NUM13 num_value
352: ,null char_value
353: ,null date_value
354: FROM DUAL
355: UNION ALL
356: SELECT 'SPC_CATEGORY_ID' attribute_name
357: ,p_TerrServReq_Rec.SQUAL_NUM14 num_value
358: ,null char_value

Line 360: FROM DUAL

356: SELECT 'SPC_CATEGORY_ID' attribute_name
357: ,p_TerrServReq_Rec.SQUAL_NUM14 num_value
358: ,null char_value
359: ,null date_value
360: FROM DUAL
361: UNION ALL
362: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
363: ,p_TerrServReq_Rec.SQUAL_NUM15 num_value
364: ,null char_value

Line 366: FROM DUAL

362: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
363: ,p_TerrServReq_Rec.SQUAL_NUM15 num_value
364: ,null char_value
365: ,null date_value
366: FROM DUAL
367: UNION ALL
368: SELECT 'PCS_ORG_ID' attribute_name
369: ,p_TerrServReq_Rec.SQUAL_NUM16 num_value
370: ,null char_value

Line 372: FROM DUAL

368: SELECT 'PCS_ORG_ID' attribute_name
369: ,p_TerrServReq_Rec.SQUAL_NUM16 num_value
370: ,null char_value
371: ,null date_value
372: FROM DUAL
373: UNION ALL
374: SELECT 'PCS_COMPONENT_ID' attribute_name
375: ,p_TerrServReq_Rec.SQUAL_NUM23 num_value
376: ,null char_value

Line 378: FROM DUAL

374: SELECT 'PCS_COMPONENT_ID' attribute_name
375: ,p_TerrServReq_Rec.SQUAL_NUM23 num_value
376: ,null char_value
377: ,null date_value
378: FROM DUAL
379: UNION ALL
380: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
381: ,p_TerrServReq_Rec.SQUAL_NUM24 num_value
382: ,null char_value

Line 384: FROM DUAL

380: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
381: ,p_TerrServReq_Rec.SQUAL_NUM24 num_value
382: ,null char_value
383: ,null date_value
384: FROM DUAL
385: UNION ALL
386: SELECT 'SR_GROUP_OWNER_ID' attribute_name
387: ,p_TerrServReq_Rec.SQUAL_NUM17 num_value
388: ,null char_value

Line 390: FROM DUAL

386: SELECT 'SR_GROUP_OWNER_ID' attribute_name
387: ,p_TerrServReq_Rec.SQUAL_NUM17 num_value
388: ,null char_value
389: ,null date_value
390: FROM DUAL
391: UNION ALL
392: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
393: ,p_TerrServReq_Rec.SQUAL_NUM18 num_value
394: ,null char_value

Line 396: FROM DUAL

392: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
393: ,p_TerrServReq_Rec.SQUAL_NUM18 num_value
394: ,null char_value
395: ,null date_value
396: FROM DUAL
397: UNION ALL
398: SELECT 'SSI_ORG_ID' attribute_name
399: ,p_TerrServReq_Rec.SQUAL_NUM19 num_value
400: ,null char_value

Line 402: FROM DUAL

398: SELECT 'SSI_ORG_ID' attribute_name
399: ,p_TerrServReq_Rec.SQUAL_NUM19 num_value
400: ,null char_value
401: ,null date_value
402: FROM DUAL
403: UNION ALL
404: SELECT 'DAY_OF_WEEK' attribute_name
405: ,null num_value
406: --,p_TerrServReq_Rec.DAY_OF_WEEK char_value

Line 410: FROM DUAL

406: --,p_TerrServReq_Rec.DAY_OF_WEEK char_value
407: , DECODE(p_TerrServReq_Rec.DAY_OF_WEEK,FND_API.G_MISS_CHAR,null,
408: p_TerrServReq_Rec.DAY_OF_WEEK) char_value
409: ,null date_value
410: FROM DUAL
411: UNION ALL
412: SELECT 'TIME_OF_DAY' attribute_name
413: , null num_value
414: --, p_TerrServReq_Rec.TIME_OF_DAY char_value

Line 418: FROM DUAL

414: --, p_TerrServReq_Rec.TIME_OF_DAY char_value
415: , DECODE(p_TerrServReq_Rec.TIME_OF_DAY,FND_API.G_MISS_CHAR,null,
416: p_TerrServReq_Rec.TIME_OF_DAY) char_value
417: ,null date_value
418: FROM DUAL
419: UNION ALL
420: SELECT 'SYSTEM_ID' attribute_name
421: ,p_TerrServReq_Rec.SQUAL_NUM60 num_value
422: ,null char_value

Line 424: FROM DUAL

420: SELECT 'SYSTEM_ID' attribute_name
421: ,p_TerrServReq_Rec.SQUAL_NUM60 num_value
422: ,null char_value
423: ,null date_value
424: FROM DUAL
425: );
426:
427: /*
428: lp_Rec.squal_num01 := jtf_terr_number_list(p_TerrServReq_Rec.party_id);

Line 739: FROM DUAL

735: ( SELECT 'COUNTRY' attribute_name
736: ,null num_value
737: ,p_TerrSrvTask_Rec.COUNTRY char_value
738: ,null date_value
739: FROM DUAL
740: UNION ALL
741: SELECT 'CITY' attribute_name
742: ,null num_value
743: ,upper(p_TerrSrvTask_Rec.CITY) char_value

Line 745: FROM DUAL

741: SELECT 'CITY' attribute_name
742: ,null num_value
743: ,upper(p_TerrSrvTask_Rec.CITY) char_value
744: ,null date_value
745: FROM DUAL
746: UNION ALL
747: SELECT 'POSTAL_CODE' attribute_name
748: ,null num_value
749: ,p_TerrSrvTask_Rec.POSTAL_CODE char_value

Line 751: FROM DUAL

747: SELECT 'POSTAL_CODE' attribute_name
748: ,null num_value
749: ,p_TerrSrvTask_Rec.POSTAL_CODE char_value
750: ,null date_value
751: FROM DUAL
752: UNION ALL
753: SELECT 'STATE' attribute_name
754: ,null num_value
755: ,p_TerrSrvTask_Rec.STATE char_value

Line 757: FROM DUAL

753: SELECT 'STATE' attribute_name
754: ,null num_value
755: ,p_TerrSrvTask_Rec.STATE char_value
756: ,null date_value
757: FROM DUAL
758: UNION ALL
759: SELECT 'AREA_CODE' attribute_name
760: ,null num_value
761: ,p_TerrSrvTask_Rec.AREA_CODE char_value

Line 763: FROM DUAL

759: SELECT 'AREA_CODE' attribute_name
760: ,null num_value
761: ,p_TerrSrvTask_Rec.AREA_CODE char_value
762: ,null date_value
763: FROM DUAL
764: UNION ALL
765: SELECT 'COUNTY' attribute_name
766: ,null num_value
767: ,p_TerrSrvTask_Rec.COUNTY char_value

Line 769: FROM DUAL

765: SELECT 'COUNTY' attribute_name
766: ,null num_value
767: ,p_TerrSrvTask_Rec.COUNTY char_value
768: ,null date_value
769: FROM DUAL
770: UNION ALL
771: SELECT 'COMP_NAME_RANGE' attribute_name
772: ,null num_value
773: ,p_TerrSrvTask_Rec.COMP_NAME_RANGE char_value

Line 775: FROM DUAL

771: SELECT 'COMP_NAME_RANGE' attribute_name
772: ,null num_value
773: ,p_TerrSrvTask_Rec.COMP_NAME_RANGE char_value
774: ,null date_value
775: FROM DUAL
776: UNION ALL
777: SELECT 'PROVINCE' attribute_name
778: ,null num_value
779: ,p_TerrSrvTask_Rec.PROVINCE char_value

Line 781: FROM DUAL

777: SELECT 'PROVINCE' attribute_name
778: ,null num_value
779: ,p_TerrSrvTask_Rec.PROVINCE char_value
780: ,null date_value
781: FROM DUAL
782: UNION ALL
783: SELECT 'PROBLEM_CODE' attribute_name
784: ,null num_value
785: ,p_TerrSrvTask_Rec.PROBLEM_CODE char_value

Line 787: FROM DUAL

783: SELECT 'PROBLEM_CODE' attribute_name
784: ,null num_value
785: ,p_TerrSrvTask_Rec.PROBLEM_CODE char_value
786: ,null date_value
787: FROM DUAL
788: UNION ALL
789: SELECT 'SR_CREATION_CHANNEL' attribute_name
790: ,null num_value
791: ,p_TerrSrvTask_Rec.SR_CREATION_CHANNEL char_value

Line 793: FROM DUAL

789: SELECT 'SR_CREATION_CHANNEL' attribute_name
790: ,null num_value
791: ,p_TerrSrvTask_Rec.SR_CREATION_CHANNEL char_value
792: ,null date_value
793: FROM DUAL
794: UNION ALL
795: SELECT 'VIP_CUSTOMER' attribute_name
796: ,null num_value
797: ,p_TerrSrvTask_Rec.squal_char11 char_value

Line 799: FROM DUAL

795: SELECT 'VIP_CUSTOMER' attribute_name
796: ,null num_value
797: ,p_TerrSrvTask_Rec.squal_char11 char_value
798: ,null date_value
799: FROM DUAL
800: UNION ALL
801: SELECT 'SR_PROBLEM_CODE' attribute_name
802: ,null num_value
803: ,p_TerrSrvTask_Rec.squal_char12 char_value

Line 805: FROM DUAL

801: SELECT 'SR_PROBLEM_CODE' attribute_name
802: ,null num_value
803: ,p_TerrSrvTask_Rec.squal_char12 char_value
804: ,null date_value
805: FROM DUAL
806: UNION ALL
807: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
808: ,null num_value
809: ,p_TerrSrvTask_Rec.squal_char13 char_value

Line 811: FROM DUAL

807: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
808: ,null num_value
809: ,p_TerrSrvTask_Rec.squal_char13 char_value
810: ,null date_value
811: FROM DUAL
812: UNION ALL
813: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
814: ,null num_value
815: ,p_TerrSrvTask_Rec.squal_char21 char_value

Line 817: FROM DUAL

813: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
814: ,null num_value
815: ,p_TerrSrvTask_Rec.squal_char21 char_value
816: ,null date_value
817: FROM DUAL
818: UNION ALL
819: SELECT 'SR_LANGUAGE' attribute_name
820: ,null num_value
821: ,p_TerrSrvTask_Rec.squal_char20 char_value

Line 823: FROM DUAL

819: SELECT 'SR_LANGUAGE' attribute_name
820: ,null num_value
821: ,p_TerrSrvTask_Rec.squal_char20 char_value
822: ,null date_value
823: FROM DUAL
824: UNION ALL
825: SELECT 'PARTY_ID' attribute_name
826: ,p_TerrSrvTask_Rec.PARTY_ID num_value
827: ,null char_value

Line 829: FROM DUAL

825: SELECT 'PARTY_ID' attribute_name
826: ,p_TerrSrvTask_Rec.PARTY_ID num_value
827: ,null char_value
828: ,null date_value
829: FROM DUAL
830: UNION ALL
831: SELECT 'PARTY_SITE_ID' attribute_name
832: ,p_TerrSrvTask_Rec.PARTY_SITE_ID num_value
833: ,null char_value

Line 835: FROM DUAL

831: SELECT 'PARTY_SITE_ID' attribute_name
832: ,p_TerrSrvTask_Rec.PARTY_SITE_ID num_value
833: ,null char_value
834: ,null date_value
835: FROM DUAL
836: UNION ALL
837: SELECT 'NUM_OF_EMPLOYEES' attribute_name
838: ,p_TerrSrvTask_Rec.NUM_OF_EMPLOYEES num_value
839: ,null char_value

Line 841: FROM DUAL

837: SELECT 'NUM_OF_EMPLOYEES' attribute_name
838: ,p_TerrSrvTask_Rec.NUM_OF_EMPLOYEES num_value
839: ,null char_value
840: ,null date_value
841: FROM DUAL
842: UNION ALL
843: SELECT 'INCIDENT_TYPE_ID' attribute_name
844: ,p_TerrSrvTask_Rec.INCIDENT_TYPE_ID num_value
845: ,null char_value

Line 847: FROM DUAL

843: SELECT 'INCIDENT_TYPE_ID' attribute_name
844: ,p_TerrSrvTask_Rec.INCIDENT_TYPE_ID num_value
845: ,null char_value
846: ,null date_value
847: FROM DUAL
848: UNION ALL
849: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
850: ,p_TerrSrvTask_Rec.INCIDENT_SEVERITY_ID num_value
851: ,null char_value

Line 853: FROM DUAL

849: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
850: ,p_TerrSrvTask_Rec.INCIDENT_SEVERITY_ID num_value
851: ,null char_value
852: ,null date_value
853: FROM DUAL
854: UNION ALL
855: SELECT 'INCIDENT_URGENCY_ID' attribute_name
856: ,p_TerrSrvTask_Rec.INCIDENT_URGENCY_ID num_value
857: ,null char_value

Line 859: FROM DUAL

855: SELECT 'INCIDENT_URGENCY_ID' attribute_name
856: ,p_TerrSrvTask_Rec.INCIDENT_URGENCY_ID num_value
857: ,null char_value
858: ,null date_value
859: FROM DUAL
860: UNION ALL
861: SELECT 'INCIDENT_STATUS_ID' attribute_name
862: ,p_TerrSrvTask_Rec.INCIDENT_STATUS_ID num_value
863: ,null char_value

Line 865: FROM DUAL

861: SELECT 'INCIDENT_STATUS_ID' attribute_name
862: ,p_TerrSrvTask_Rec.INCIDENT_STATUS_ID num_value
863: ,null char_value
864: ,null date_value
865: FROM DUAL
866: UNION ALL
867: SELECT 'PLATFORM_ID' attribute_name
868: ,p_TerrSrvTask_Rec.PLATFORM_ID num_value
869: ,null char_value

Line 871: FROM DUAL

867: SELECT 'PLATFORM_ID' attribute_name
868: ,p_TerrSrvTask_Rec.PLATFORM_ID num_value
869: ,null char_value
870: ,null date_value
871: FROM DUAL
872: UNION ALL
873: SELECT 'SUPPORT_SITE_ID' attribute_name
874: ,p_TerrSrvTask_Rec.SUPPORT_SITE_ID num_value
875: ,null char_value

Line 877: FROM DUAL

873: SELECT 'SUPPORT_SITE_ID' attribute_name
874: ,p_TerrSrvTask_Rec.SUPPORT_SITE_ID num_value
875: ,null char_value
876: ,null date_value
877: FROM DUAL
878: UNION ALL
879: SELECT 'CUSTOMER_SITE_ID' attribute_name
880: ,p_TerrSrvTask_Rec.CUSTOMER_SITE_ID num_value
881: ,null char_value

Line 883: FROM DUAL

879: SELECT 'CUSTOMER_SITE_ID' attribute_name
880: ,p_TerrSrvTask_Rec.CUSTOMER_SITE_ID num_value
881: ,null char_value
882: ,null date_value
883: FROM DUAL
884: UNION ALL
885: SELECT 'INVENTORY_ITEM_ID' attribute_name
886: ,p_TerrSrvTask_Rec.INVENTORY_ITEM_ID num_value
887: ,null char_value

Line 889: FROM DUAL

885: SELECT 'INVENTORY_ITEM_ID' attribute_name
886: ,p_TerrSrvTask_Rec.INVENTORY_ITEM_ID num_value
887: ,null char_value
888: ,null date_value
889: FROM DUAL
890: UNION ALL
891: SELECT 'TASK_TYPE_ID' attribute_name
892: ,p_TerrSrvTask_Rec.TASK_TYPE_ID num_value
893: ,null char_value

Line 895: FROM DUAL

891: SELECT 'TASK_TYPE_ID' attribute_name
892: ,p_TerrSrvTask_Rec.TASK_TYPE_ID num_value
893: ,null char_value
894: ,null date_value
895: FROM DUAL
896: UNION ALL
897: SELECT 'TASK_STATUS_ID' attribute_name
898: ,p_TerrSrvTask_Rec.TASK_STATUS_ID num_value
899: ,null char_value

Line 901: FROM DUAL

897: SELECT 'TASK_STATUS_ID' attribute_name
898: ,p_TerrSrvTask_Rec.TASK_STATUS_ID num_value
899: ,null char_value
900: ,null date_value
901: FROM DUAL
902: UNION ALL
903: SELECT 'TASK_PRIORITY_ID' attribute_name
904: ,p_TerrSrvTask_Rec.TASK_PRIORITY_ID num_value
905: ,null char_value

Line 907: FROM DUAL

903: SELECT 'TASK_PRIORITY_ID' attribute_name
904: ,p_TerrSrvTask_Rec.TASK_PRIORITY_ID num_value
905: ,null char_value
906: ,null date_value
907: FROM DUAL
908: UNION ALL
909: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
910: ,p_TerrSrvTask_Rec.SQUAL_NUM12 num_value
911: ,null char_value

Line 913: FROM DUAL

909: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
910: ,p_TerrSrvTask_Rec.SQUAL_NUM12 num_value
911: ,null char_value
912: ,null date_value
913: FROM DUAL
914: UNION ALL
915: SELECT 'SRP_ORG_ID' attribute_name
916: ,p_TerrSrvTask_Rec.SQUAL_NUM13 num_value
917: ,null char_value

Line 919: FROM DUAL

915: SELECT 'SRP_ORG_ID' attribute_name
916: ,p_TerrSrvTask_Rec.SQUAL_NUM13 num_value
917: ,null char_value
918: ,null date_value
919: FROM DUAL
920: UNION ALL
921: SELECT 'SPC_CATEGORY_ID' attribute_name
922: ,p_TerrSrvTask_Rec.SQUAL_NUM14 num_value
923: ,null char_value

Line 925: FROM DUAL

921: SELECT 'SPC_CATEGORY_ID' attribute_name
922: ,p_TerrSrvTask_Rec.SQUAL_NUM14 num_value
923: ,null char_value
924: ,null date_value
925: FROM DUAL
926: UNION ALL
927: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
928: ,p_TerrSrvTask_Rec.SQUAL_NUM15 num_value
929: ,null char_value

Line 931: FROM DUAL

927: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
928: ,p_TerrSrvTask_Rec.SQUAL_NUM15 num_value
929: ,null char_value
930: ,null date_value
931: FROM DUAL
932: UNION ALL
933: SELECT 'PCS_ORG_ID' attribute_name
934: ,p_TerrSrvTask_Rec.SQUAL_NUM16 num_value
935: ,null char_value

Line 937: FROM DUAL

933: SELECT 'PCS_ORG_ID' attribute_name
934: ,p_TerrSrvTask_Rec.SQUAL_NUM16 num_value
935: ,null char_value
936: ,null date_value
937: FROM DUAL
938: UNION ALL
939: SELECT 'PCS_COMPONENT_ID' attribute_name
940: ,p_TerrSrvTask_Rec.SQUAL_NUM23 num_value
941: ,null char_value

Line 943: FROM DUAL

939: SELECT 'PCS_COMPONENT_ID' attribute_name
940: ,p_TerrSrvTask_Rec.SQUAL_NUM23 num_value
941: ,null char_value
942: ,null date_value
943: FROM DUAL
944: UNION ALL
945: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
946: ,p_TerrSrvTask_Rec.SQUAL_NUM24 num_value
947: ,null char_value

Line 949: FROM DUAL

945: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
946: ,p_TerrSrvTask_Rec.SQUAL_NUM24 num_value
947: ,null char_value
948: ,null date_value
949: FROM DUAL
950: UNION ALL
951: SELECT 'SR_GROUP_OWNER_ID' attribute_name
952: ,p_TerrSrvTask_Rec.SQUAL_NUM17 num_value
953: ,null char_value

Line 955: FROM DUAL

951: SELECT 'SR_GROUP_OWNER_ID' attribute_name
952: ,p_TerrSrvTask_Rec.SQUAL_NUM17 num_value
953: ,null char_value
954: ,null date_value
955: FROM DUAL
956: UNION ALL
957: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
958: ,p_TerrSrvTask_Rec.SQUAL_NUM18 num_value
959: ,null char_value

Line 961: FROM DUAL

957: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
958: ,p_TerrSrvTask_Rec.SQUAL_NUM18 num_value
959: ,null char_value
960: ,null date_value
961: FROM DUAL
962: UNION ALL
963: SELECT 'SSI_ORG_ID' attribute_name
964: ,p_TerrSrvTask_Rec.SQUAL_NUM19 num_value
965: ,null char_value

Line 967: FROM DUAL

963: SELECT 'SSI_ORG_ID' attribute_name
964: ,p_TerrSrvTask_Rec.SQUAL_NUM19 num_value
965: ,null char_value
966: ,null date_value
967: FROM DUAL
968: UNION ALL
969: SELECT 'DAY_OF_WEEK' attribute_name
970: ,null num_value
971: --,p_TerrSrvTask_Rec.DAY_OF_WEEK char_value

Line 975: FROM DUAL

971: --,p_TerrSrvTask_Rec.DAY_OF_WEEK char_value
972: , DECODE(p_TerrSrvTask_Rec.DAY_OF_WEEK,FND_API.G_MISS_CHAR,null,
973: p_TerrSrvTask_Rec.DAY_OF_WEEK) char_value
974: ,null date_value
975: FROM DUAL
976: UNION ALL
977: SELECT 'TIME_OF_DAY' attribute_name
978: ,null num_value
979: --,p_TerrSrvTask_Rec.TIME_OF_DAY char_value

Line 983: FROM DUAL

979: --,p_TerrSrvTask_Rec.TIME_OF_DAY char_value
980: ,DECODE(p_TerrSrvTask_Rec.TIME_OF_DAY ,FND_API.G_MISS_CHAR,null,
981: p_TerrSrvTask_Rec.TIME_OF_DAY ) char_value
982: ,null date_value
983: FROM DUAL
984: UNION ALL
985: SELECT 'SYSTEM_ID' attribute_name
986: ,p_TerrSrvTask_Rec.SQUAL_NUM60 num_value
987: ,null char_value

Line 989: FROM DUAL

985: SELECT 'SYSTEM_ID' attribute_name
986: ,p_TerrSrvTask_Rec.SQUAL_NUM60 num_value
987: ,null char_value
988: ,null date_value
989: FROM DUAL
990: );
991:
992: /*
993: lp_Rec.squal_num01 := jtf_terr_number_list(p_TerrSrvTask_Rec.party_id);