APPS.JTF_TERR_SERVICE_PUB dependencies on DUAL

Line 188: FROM DUAL

184: ( SELECT 'COUNTRY' attribute_name
185: ,null num_value
186: ,p_TerrServReq_Rec.COUNTRY char_value
187: ,null date_value
188: FROM DUAL
189: UNION ALL
190: SELECT 'CITY' attribute_name
191: ,null num_value
192: ,p_TerrServReq_Rec.CITY char_value

Line 194: FROM DUAL

190: SELECT 'CITY' attribute_name
191: ,null num_value
192: ,p_TerrServReq_Rec.CITY char_value
193: ,null date_value
194: FROM DUAL
195: UNION ALL
196: SELECT 'POSTAL_CODE' attribute_name
197: ,null num_value
198: ,p_TerrServReq_Rec.POSTAL_CODE char_value

Line 200: FROM DUAL

196: SELECT 'POSTAL_CODE' attribute_name
197: ,null num_value
198: ,p_TerrServReq_Rec.POSTAL_CODE char_value
199: ,null date_value
200: FROM DUAL
201: UNION ALL
202: SELECT 'STATE' attribute_name
203: ,null num_value
204: ,p_TerrServReq_Rec.STATE char_value

Line 206: FROM DUAL

202: SELECT 'STATE' attribute_name
203: ,null num_value
204: ,p_TerrServReq_Rec.STATE char_value
205: ,null date_value
206: FROM DUAL
207: UNION ALL
208: SELECT 'AREA_CODE' attribute_name
209: ,null num_value
210: ,p_TerrServReq_Rec.AREA_CODE char_value

Line 212: FROM DUAL

208: SELECT 'AREA_CODE' attribute_name
209: ,null num_value
210: ,p_TerrServReq_Rec.AREA_CODE char_value
211: ,null date_value
212: FROM DUAL
213: UNION ALL
214: SELECT 'COUNTY' attribute_name
215: ,null num_value
216: ,p_TerrServReq_Rec.COUNTY char_value

Line 218: FROM DUAL

214: SELECT 'COUNTY' attribute_name
215: ,null num_value
216: ,p_TerrServReq_Rec.COUNTY char_value
217: ,null date_value
218: FROM DUAL
219: UNION ALL
220: SELECT 'COMP_NAME_RANGE' attribute_name
221: ,null num_value
222: ,p_TerrServReq_Rec.COMP_NAME_RANGE char_value

Line 224: FROM DUAL

220: SELECT 'COMP_NAME_RANGE' attribute_name
221: ,null num_value
222: ,p_TerrServReq_Rec.COMP_NAME_RANGE char_value
223: ,null date_value
224: FROM DUAL
225: UNION ALL
226: SELECT 'PROVINCE' attribute_name
227: ,null num_value
228: ,p_TerrServReq_Rec.PROVINCE char_value

Line 230: FROM DUAL

226: SELECT 'PROVINCE' attribute_name
227: ,null num_value
228: ,p_TerrServReq_Rec.PROVINCE char_value
229: ,null date_value
230: FROM DUAL
231: UNION ALL
232: SELECT 'PROBLEM_CODE' attribute_name
233: ,null num_value
234: ,p_TerrServReq_Rec.PROBLEM_CODE char_value

Line 236: FROM DUAL

232: SELECT 'PROBLEM_CODE' attribute_name
233: ,null num_value
234: ,p_TerrServReq_Rec.PROBLEM_CODE char_value
235: ,null date_value
236: FROM DUAL
237: UNION ALL
238: SELECT 'SR_CREATION_CHANNEL' attribute_name
239: ,null num_value
240: ,p_TerrServReq_Rec.SR_CREATION_CHANNEL char_value

Line 242: FROM DUAL

238: SELECT 'SR_CREATION_CHANNEL' attribute_name
239: ,null num_value
240: ,p_TerrServReq_Rec.SR_CREATION_CHANNEL char_value
241: ,null date_value
242: FROM DUAL
243: UNION ALL
244: SELECT 'VIP_CUSTOMER' attribute_name
245: ,null num_value
246: ,p_TerrServReq_Rec.squal_char11 char_value

Line 248: FROM DUAL

244: SELECT 'VIP_CUSTOMER' attribute_name
245: ,null num_value
246: ,p_TerrServReq_Rec.squal_char11 char_value
247: ,null date_value
248: FROM DUAL
249: UNION ALL
250: SELECT 'SR_PROBLEM_CODE' attribute_name
251: ,null num_value
252: ,p_TerrServReq_Rec.squal_char12 char_value

Line 254: FROM DUAL

250: SELECT 'SR_PROBLEM_CODE' attribute_name
251: ,null num_value
252: ,p_TerrServReq_Rec.squal_char12 char_value
253: ,null date_value
254: FROM DUAL
255: UNION ALL
256: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
257: ,null num_value
258: ,p_TerrServReq_Rec.squal_char13 char_value

Line 260: FROM DUAL

256: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
257: ,null num_value
258: ,p_TerrServReq_Rec.squal_char13 char_value
259: ,null date_value
260: FROM DUAL
261: UNION ALL
262: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
263: ,null num_value
264: ,p_TerrServReq_Rec.squal_char21 char_value

Line 266: FROM DUAL

262: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
263: ,null num_value
264: ,p_TerrServReq_Rec.squal_char21 char_value
265: ,null date_value
266: FROM DUAL
267: UNION ALL
268: SELECT 'SR_LANGUAGE' attribute_name
269: ,null num_value
270: ,p_TerrServReq_Rec.squal_char20 char_value

Line 272: FROM DUAL

268: SELECT 'SR_LANGUAGE' attribute_name
269: ,null num_value
270: ,p_TerrServReq_Rec.squal_char20 char_value
271: ,null date_value
272: FROM DUAL
273: UNION ALL
274: SELECT 'PARTY_ID' attribute_name
275: ,p_TerrServReq_Rec.PARTY_ID num_value
276: ,null char_value

Line 278: FROM DUAL

274: SELECT 'PARTY_ID' attribute_name
275: ,p_TerrServReq_Rec.PARTY_ID num_value
276: ,null char_value
277: ,null date_value
278: FROM DUAL
279: UNION ALL
280: SELECT 'PARTY_SITE_ID' attribute_name
281: ,p_TerrServReq_Rec.PARTY_SITE_ID num_value
282: ,null char_value

Line 284: FROM DUAL

280: SELECT 'PARTY_SITE_ID' attribute_name
281: ,p_TerrServReq_Rec.PARTY_SITE_ID num_value
282: ,null char_value
283: ,null date_value
284: FROM DUAL
285: UNION ALL
286: SELECT 'NUM_OF_EMPLOYEES' attribute_name
287: ,p_TerrServReq_Rec.NUM_OF_EMPLOYEES num_value
288: ,null char_value

Line 290: FROM DUAL

286: SELECT 'NUM_OF_EMPLOYEES' attribute_name
287: ,p_TerrServReq_Rec.NUM_OF_EMPLOYEES num_value
288: ,null char_value
289: ,null date_value
290: FROM DUAL
291: UNION ALL
292: SELECT 'INCIDENT_TYPE_ID' attribute_name
293: ,p_TerrServReq_Rec.INCIDENT_TYPE_ID num_value
294: ,null char_value

Line 296: FROM DUAL

292: SELECT 'INCIDENT_TYPE_ID' attribute_name
293: ,p_TerrServReq_Rec.INCIDENT_TYPE_ID num_value
294: ,null char_value
295: ,null date_value
296: FROM DUAL
297: UNION ALL
298: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
299: ,p_TerrServReq_Rec.INCIDENT_SEVERITY_ID num_value
300: ,null char_value

Line 302: FROM DUAL

298: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
299: ,p_TerrServReq_Rec.INCIDENT_SEVERITY_ID num_value
300: ,null char_value
301: ,null date_value
302: FROM DUAL
303: UNION ALL
304: SELECT 'INCIDENT_URGENCY_ID' attribute_name
305: ,p_TerrServReq_Rec.INCIDENT_URGENCY_ID num_value
306: ,null char_value

Line 308: FROM DUAL

304: SELECT 'INCIDENT_URGENCY_ID' attribute_name
305: ,p_TerrServReq_Rec.INCIDENT_URGENCY_ID num_value
306: ,null char_value
307: ,null date_value
308: FROM DUAL
309: UNION ALL
310: SELECT 'INCIDENT_STATUS_ID' attribute_name
311: ,p_TerrServReq_Rec.INCIDENT_STATUS_ID num_value
312: ,null char_value

Line 314: FROM DUAL

310: SELECT 'INCIDENT_STATUS_ID' attribute_name
311: ,p_TerrServReq_Rec.INCIDENT_STATUS_ID num_value
312: ,null char_value
313: ,null date_value
314: FROM DUAL
315: UNION ALL
316: SELECT 'PLATFORM_ID' attribute_name
317: ,p_TerrServReq_Rec.PLATFORM_ID num_value
318: ,null char_value

Line 320: FROM DUAL

316: SELECT 'PLATFORM_ID' attribute_name
317: ,p_TerrServReq_Rec.PLATFORM_ID num_value
318: ,null char_value
319: ,null date_value
320: FROM DUAL
321: UNION ALL
322: SELECT 'SUPPORT_SITE_ID' attribute_name
323: ,p_TerrServReq_Rec.SUPPORT_SITE_ID num_value
324: ,null char_value

Line 326: FROM DUAL

322: SELECT 'SUPPORT_SITE_ID' attribute_name
323: ,p_TerrServReq_Rec.SUPPORT_SITE_ID num_value
324: ,null char_value
325: ,null date_value
326: FROM DUAL
327: UNION ALL
328: SELECT 'CUSTOMER_SITE_ID' attribute_name
329: ,p_TerrServReq_Rec.CUSTOMER_SITE_ID num_value
330: ,null char_value

Line 332: FROM DUAL

328: SELECT 'CUSTOMER_SITE_ID' attribute_name
329: ,p_TerrServReq_Rec.CUSTOMER_SITE_ID num_value
330: ,null char_value
331: ,null date_value
332: FROM DUAL
333: UNION ALL
334: SELECT 'INVENTORY_ITEM_ID' attribute_name
335: ,p_TerrServReq_Rec.INVENTORY_ITEM_ID num_value
336: ,null char_value

Line 338: FROM DUAL

334: SELECT 'INVENTORY_ITEM_ID' attribute_name
335: ,p_TerrServReq_Rec.INVENTORY_ITEM_ID num_value
336: ,null char_value
337: ,null date_value
338: FROM DUAL
339: UNION ALL
340: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
341: ,p_TerrServReq_Rec.SQUAL_NUM12 num_value
342: ,null char_value

Line 344: FROM DUAL

340: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
341: ,p_TerrServReq_Rec.SQUAL_NUM12 num_value
342: ,null char_value
343: ,null date_value
344: FROM DUAL
345: UNION ALL
346: SELECT 'SRP_ORG_ID' attribute_name
347: ,p_TerrServReq_Rec.SQUAL_NUM13 num_value
348: ,null char_value

Line 350: FROM DUAL

346: SELECT 'SRP_ORG_ID' attribute_name
347: ,p_TerrServReq_Rec.SQUAL_NUM13 num_value
348: ,null char_value
349: ,null date_value
350: FROM DUAL
351: UNION ALL
352: SELECT 'SPC_CATEGORY_ID' attribute_name
353: ,p_TerrServReq_Rec.SQUAL_NUM14 num_value
354: ,null char_value

Line 356: FROM DUAL

352: SELECT 'SPC_CATEGORY_ID' attribute_name
353: ,p_TerrServReq_Rec.SQUAL_NUM14 num_value
354: ,null char_value
355: ,null date_value
356: FROM DUAL
357: UNION ALL
358: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
359: ,p_TerrServReq_Rec.SQUAL_NUM15 num_value
360: ,null char_value

Line 362: FROM DUAL

358: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
359: ,p_TerrServReq_Rec.SQUAL_NUM15 num_value
360: ,null char_value
361: ,null date_value
362: FROM DUAL
363: UNION ALL
364: SELECT 'PCS_ORG_ID' attribute_name
365: ,p_TerrServReq_Rec.SQUAL_NUM16 num_value
366: ,null char_value

Line 368: FROM DUAL

364: SELECT 'PCS_ORG_ID' attribute_name
365: ,p_TerrServReq_Rec.SQUAL_NUM16 num_value
366: ,null char_value
367: ,null date_value
368: FROM DUAL
369: UNION ALL
370: SELECT 'PCS_COMPONENT_ID' attribute_name
371: ,p_TerrServReq_Rec.SQUAL_NUM23 num_value
372: ,null char_value

Line 374: FROM DUAL

370: SELECT 'PCS_COMPONENT_ID' attribute_name
371: ,p_TerrServReq_Rec.SQUAL_NUM23 num_value
372: ,null char_value
373: ,null date_value
374: FROM DUAL
375: UNION ALL
376: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
377: ,p_TerrServReq_Rec.SQUAL_NUM24 num_value
378: ,null char_value

Line 380: FROM DUAL

376: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
377: ,p_TerrServReq_Rec.SQUAL_NUM24 num_value
378: ,null char_value
379: ,null date_value
380: FROM DUAL
381: UNION ALL
382: SELECT 'SR_GROUP_OWNER_ID' attribute_name
383: ,p_TerrServReq_Rec.SQUAL_NUM17 num_value
384: ,null char_value

Line 386: FROM DUAL

382: SELECT 'SR_GROUP_OWNER_ID' attribute_name
383: ,p_TerrServReq_Rec.SQUAL_NUM17 num_value
384: ,null char_value
385: ,null date_value
386: FROM DUAL
387: UNION ALL
388: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
389: ,p_TerrServReq_Rec.SQUAL_NUM18 num_value
390: ,null char_value

Line 392: FROM DUAL

388: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
389: ,p_TerrServReq_Rec.SQUAL_NUM18 num_value
390: ,null char_value
391: ,null date_value
392: FROM DUAL
393: UNION ALL
394: SELECT 'SSI_ORG_ID' attribute_name
395: ,p_TerrServReq_Rec.SQUAL_NUM19 num_value
396: ,null char_value

Line 398: FROM DUAL

394: SELECT 'SSI_ORG_ID' attribute_name
395: ,p_TerrServReq_Rec.SQUAL_NUM19 num_value
396: ,null char_value
397: ,null date_value
398: FROM DUAL
399: );
400:
401: /*
402: lp_Rec.squal_num01 := jtf_terr_number_list(p_TerrServReq_Rec.party_id);

Line 710: FROM DUAL

706: ( SELECT 'COUNTRY' attribute_name
707: ,null num_value
708: ,p_TerrSrvTask_Rec.COUNTRY char_value
709: ,null date_value
710: FROM DUAL
711: UNION ALL
712: SELECT 'CITY' attribute_name
713: ,null num_value
714: ,p_TerrSrvTask_Rec.CITY char_value

Line 716: FROM DUAL

712: SELECT 'CITY' attribute_name
713: ,null num_value
714: ,p_TerrSrvTask_Rec.CITY char_value
715: ,null date_value
716: FROM DUAL
717: UNION ALL
718: SELECT 'POSTAL_CODE' attribute_name
719: ,null num_value
720: ,p_TerrSrvTask_Rec.POSTAL_CODE char_value

Line 722: FROM DUAL

718: SELECT 'POSTAL_CODE' attribute_name
719: ,null num_value
720: ,p_TerrSrvTask_Rec.POSTAL_CODE char_value
721: ,null date_value
722: FROM DUAL
723: UNION ALL
724: SELECT 'STATE' attribute_name
725: ,null num_value
726: ,p_TerrSrvTask_Rec.STATE char_value

Line 728: FROM DUAL

724: SELECT 'STATE' attribute_name
725: ,null num_value
726: ,p_TerrSrvTask_Rec.STATE char_value
727: ,null date_value
728: FROM DUAL
729: UNION ALL
730: SELECT 'AREA_CODE' attribute_name
731: ,null num_value
732: ,p_TerrSrvTask_Rec.AREA_CODE char_value

Line 734: FROM DUAL

730: SELECT 'AREA_CODE' attribute_name
731: ,null num_value
732: ,p_TerrSrvTask_Rec.AREA_CODE char_value
733: ,null date_value
734: FROM DUAL
735: UNION ALL
736: SELECT 'COUNTY' attribute_name
737: ,null num_value
738: ,p_TerrSrvTask_Rec.COUNTY char_value

Line 740: FROM DUAL

736: SELECT 'COUNTY' attribute_name
737: ,null num_value
738: ,p_TerrSrvTask_Rec.COUNTY char_value
739: ,null date_value
740: FROM DUAL
741: UNION ALL
742: SELECT 'COMP_NAME_RANGE' attribute_name
743: ,null num_value
744: ,p_TerrSrvTask_Rec.COMP_NAME_RANGE char_value

Line 746: FROM DUAL

742: SELECT 'COMP_NAME_RANGE' attribute_name
743: ,null num_value
744: ,p_TerrSrvTask_Rec.COMP_NAME_RANGE char_value
745: ,null date_value
746: FROM DUAL
747: UNION ALL
748: SELECT 'PROVINCE' attribute_name
749: ,null num_value
750: ,p_TerrSrvTask_Rec.PROVINCE char_value

Line 752: FROM DUAL

748: SELECT 'PROVINCE' attribute_name
749: ,null num_value
750: ,p_TerrSrvTask_Rec.PROVINCE char_value
751: ,null date_value
752: FROM DUAL
753: UNION ALL
754: SELECT 'PROBLEM_CODE' attribute_name
755: ,null num_value
756: ,p_TerrSrvTask_Rec.PROBLEM_CODE char_value

Line 758: FROM DUAL

754: SELECT 'PROBLEM_CODE' attribute_name
755: ,null num_value
756: ,p_TerrSrvTask_Rec.PROBLEM_CODE char_value
757: ,null date_value
758: FROM DUAL
759: UNION ALL
760: SELECT 'SR_CREATION_CHANNEL' attribute_name
761: ,null num_value
762: ,p_TerrSrvTask_Rec.SR_CREATION_CHANNEL char_value

Line 764: FROM DUAL

760: SELECT 'SR_CREATION_CHANNEL' attribute_name
761: ,null num_value
762: ,p_TerrSrvTask_Rec.SR_CREATION_CHANNEL char_value
763: ,null date_value
764: FROM DUAL
765: UNION ALL
766: SELECT 'VIP_CUSTOMER' attribute_name
767: ,null num_value
768: ,p_TerrSrvTask_Rec.squal_char11 char_value

Line 770: FROM DUAL

766: SELECT 'VIP_CUSTOMER' attribute_name
767: ,null num_value
768: ,p_TerrSrvTask_Rec.squal_char11 char_value
769: ,null date_value
770: FROM DUAL
771: UNION ALL
772: SELECT 'SR_PROBLEM_CODE' attribute_name
773: ,null num_value
774: ,p_TerrSrvTask_Rec.squal_char12 char_value

Line 776: FROM DUAL

772: SELECT 'SR_PROBLEM_CODE' attribute_name
773: ,null num_value
774: ,p_TerrSrvTask_Rec.squal_char12 char_value
775: ,null date_value
776: FROM DUAL
777: UNION ALL
778: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
779: ,null num_value
780: ,p_TerrSrvTask_Rec.squal_char13 char_value

Line 782: FROM DUAL

778: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
779: ,null num_value
780: ,p_TerrSrvTask_Rec.squal_char13 char_value
781: ,null date_value
782: FROM DUAL
783: UNION ALL
784: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
785: ,null num_value
786: ,p_TerrSrvTask_Rec.squal_char21 char_value

Line 788: FROM DUAL

784: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
785: ,null num_value
786: ,p_TerrSrvTask_Rec.squal_char21 char_value
787: ,null date_value
788: FROM DUAL
789: UNION ALL
790: SELECT 'SR_LANGUAGE' attribute_name
791: ,null num_value
792: ,p_TerrSrvTask_Rec.squal_char20 char_value

Line 794: FROM DUAL

790: SELECT 'SR_LANGUAGE' attribute_name
791: ,null num_value
792: ,p_TerrSrvTask_Rec.squal_char20 char_value
793: ,null date_value
794: FROM DUAL
795: UNION ALL
796: SELECT 'PARTY_ID' attribute_name
797: ,p_TerrSrvTask_Rec.PARTY_ID num_value
798: ,null char_value

Line 800: FROM DUAL

796: SELECT 'PARTY_ID' attribute_name
797: ,p_TerrSrvTask_Rec.PARTY_ID num_value
798: ,null char_value
799: ,null date_value
800: FROM DUAL
801: UNION ALL
802: SELECT 'PARTY_SITE_ID' attribute_name
803: ,p_TerrSrvTask_Rec.PARTY_SITE_ID num_value
804: ,null char_value

Line 806: FROM DUAL

802: SELECT 'PARTY_SITE_ID' attribute_name
803: ,p_TerrSrvTask_Rec.PARTY_SITE_ID num_value
804: ,null char_value
805: ,null date_value
806: FROM DUAL
807: UNION ALL
808: SELECT 'NUM_OF_EMPLOYEES' attribute_name
809: ,p_TerrSrvTask_Rec.NUM_OF_EMPLOYEES num_value
810: ,null char_value

Line 812: FROM DUAL

808: SELECT 'NUM_OF_EMPLOYEES' attribute_name
809: ,p_TerrSrvTask_Rec.NUM_OF_EMPLOYEES num_value
810: ,null char_value
811: ,null date_value
812: FROM DUAL
813: UNION ALL
814: SELECT 'INCIDENT_TYPE_ID' attribute_name
815: ,p_TerrSrvTask_Rec.INCIDENT_TYPE_ID num_value
816: ,null char_value

Line 818: FROM DUAL

814: SELECT 'INCIDENT_TYPE_ID' attribute_name
815: ,p_TerrSrvTask_Rec.INCIDENT_TYPE_ID num_value
816: ,null char_value
817: ,null date_value
818: FROM DUAL
819: UNION ALL
820: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
821: ,p_TerrSrvTask_Rec.INCIDENT_SEVERITY_ID num_value
822: ,null char_value

Line 824: FROM DUAL

820: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
821: ,p_TerrSrvTask_Rec.INCIDENT_SEVERITY_ID num_value
822: ,null char_value
823: ,null date_value
824: FROM DUAL
825: UNION ALL
826: SELECT 'INCIDENT_URGENCY_ID' attribute_name
827: ,p_TerrSrvTask_Rec.INCIDENT_URGENCY_ID num_value
828: ,null char_value

Line 830: FROM DUAL

826: SELECT 'INCIDENT_URGENCY_ID' attribute_name
827: ,p_TerrSrvTask_Rec.INCIDENT_URGENCY_ID num_value
828: ,null char_value
829: ,null date_value
830: FROM DUAL
831: UNION ALL
832: SELECT 'INCIDENT_STATUS_ID' attribute_name
833: ,p_TerrSrvTask_Rec.INCIDENT_STATUS_ID num_value
834: ,null char_value

Line 836: FROM DUAL

832: SELECT 'INCIDENT_STATUS_ID' attribute_name
833: ,p_TerrSrvTask_Rec.INCIDENT_STATUS_ID num_value
834: ,null char_value
835: ,null date_value
836: FROM DUAL
837: UNION ALL
838: SELECT 'PLATFORM_ID' attribute_name
839: ,p_TerrSrvTask_Rec.PLATFORM_ID num_value
840: ,null char_value

Line 842: FROM DUAL

838: SELECT 'PLATFORM_ID' attribute_name
839: ,p_TerrSrvTask_Rec.PLATFORM_ID num_value
840: ,null char_value
841: ,null date_value
842: FROM DUAL
843: UNION ALL
844: SELECT 'SUPPORT_SITE_ID' attribute_name
845: ,p_TerrSrvTask_Rec.SUPPORT_SITE_ID num_value
846: ,null char_value

Line 848: FROM DUAL

844: SELECT 'SUPPORT_SITE_ID' attribute_name
845: ,p_TerrSrvTask_Rec.SUPPORT_SITE_ID num_value
846: ,null char_value
847: ,null date_value
848: FROM DUAL
849: UNION ALL
850: SELECT 'CUSTOMER_SITE_ID' attribute_name
851: ,p_TerrSrvTask_Rec.CUSTOMER_SITE_ID num_value
852: ,null char_value

Line 854: FROM DUAL

850: SELECT 'CUSTOMER_SITE_ID' attribute_name
851: ,p_TerrSrvTask_Rec.CUSTOMER_SITE_ID num_value
852: ,null char_value
853: ,null date_value
854: FROM DUAL
855: UNION ALL
856: SELECT 'INVENTORY_ITEM_ID' attribute_name
857: ,p_TerrSrvTask_Rec.INVENTORY_ITEM_ID num_value
858: ,null char_value

Line 860: FROM DUAL

856: SELECT 'INVENTORY_ITEM_ID' attribute_name
857: ,p_TerrSrvTask_Rec.INVENTORY_ITEM_ID num_value
858: ,null char_value
859: ,null date_value
860: FROM DUAL
861: UNION ALL
862: SELECT 'TASK_TYPE_ID' attribute_name
863: ,p_TerrSrvTask_Rec.TASK_TYPE_ID num_value
864: ,null char_value

Line 866: FROM DUAL

862: SELECT 'TASK_TYPE_ID' attribute_name
863: ,p_TerrSrvTask_Rec.TASK_TYPE_ID num_value
864: ,null char_value
865: ,null date_value
866: FROM DUAL
867: UNION ALL
868: SELECT 'TASK_STATUS_ID' attribute_name
869: ,p_TerrSrvTask_Rec.TASK_STATUS_ID num_value
870: ,null char_value

Line 872: FROM DUAL

868: SELECT 'TASK_STATUS_ID' attribute_name
869: ,p_TerrSrvTask_Rec.TASK_STATUS_ID num_value
870: ,null char_value
871: ,null date_value
872: FROM DUAL
873: UNION ALL
874: SELECT 'TASK_PRIORITY_ID' attribute_name
875: ,p_TerrSrvTask_Rec.TASK_PRIORITY_ID num_value
876: ,null char_value

Line 878: FROM DUAL

874: SELECT 'TASK_PRIORITY_ID' attribute_name
875: ,p_TerrSrvTask_Rec.TASK_PRIORITY_ID num_value
876: ,null char_value
877: ,null date_value
878: FROM DUAL
879: UNION ALL
880: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
881: ,p_TerrSrvTask_Rec.SQUAL_NUM12 num_value
882: ,null char_value

Line 884: FROM DUAL

880: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
881: ,p_TerrSrvTask_Rec.SQUAL_NUM12 num_value
882: ,null char_value
883: ,null date_value
884: FROM DUAL
885: UNION ALL
886: SELECT 'SRP_ORG_ID' attribute_name
887: ,p_TerrSrvTask_Rec.SQUAL_NUM13 num_value
888: ,null char_value

Line 890: FROM DUAL

886: SELECT 'SRP_ORG_ID' attribute_name
887: ,p_TerrSrvTask_Rec.SQUAL_NUM13 num_value
888: ,null char_value
889: ,null date_value
890: FROM DUAL
891: UNION ALL
892: SELECT 'SPC_CATEGORY_ID' attribute_name
893: ,p_TerrSrvTask_Rec.SQUAL_NUM14 num_value
894: ,null char_value

Line 896: FROM DUAL

892: SELECT 'SPC_CATEGORY_ID' attribute_name
893: ,p_TerrSrvTask_Rec.SQUAL_NUM14 num_value
894: ,null char_value
895: ,null date_value
896: FROM DUAL
897: UNION ALL
898: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
899: ,p_TerrSrvTask_Rec.SQUAL_NUM15 num_value
900: ,null char_value

Line 902: FROM DUAL

898: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
899: ,p_TerrSrvTask_Rec.SQUAL_NUM15 num_value
900: ,null char_value
901: ,null date_value
902: FROM DUAL
903: UNION ALL
904: SELECT 'PCS_ORG_ID' attribute_name
905: ,p_TerrSrvTask_Rec.SQUAL_NUM16 num_value
906: ,null char_value

Line 908: FROM DUAL

904: SELECT 'PCS_ORG_ID' attribute_name
905: ,p_TerrSrvTask_Rec.SQUAL_NUM16 num_value
906: ,null char_value
907: ,null date_value
908: FROM DUAL
909: UNION ALL
910: SELECT 'PCS_COMPONENT_ID' attribute_name
911: ,p_TerrSrvTask_Rec.SQUAL_NUM23 num_value
912: ,null char_value

Line 914: FROM DUAL

910: SELECT 'PCS_COMPONENT_ID' attribute_name
911: ,p_TerrSrvTask_Rec.SQUAL_NUM23 num_value
912: ,null char_value
913: ,null date_value
914: FROM DUAL
915: UNION ALL
916: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
917: ,p_TerrSrvTask_Rec.SQUAL_NUM24 num_value
918: ,null char_value

Line 920: FROM DUAL

916: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
917: ,p_TerrSrvTask_Rec.SQUAL_NUM24 num_value
918: ,null char_value
919: ,null date_value
920: FROM DUAL
921: UNION ALL
922: SELECT 'SR_GROUP_OWNER_ID' attribute_name
923: ,p_TerrSrvTask_Rec.SQUAL_NUM17 num_value
924: ,null char_value

Line 926: FROM DUAL

922: SELECT 'SR_GROUP_OWNER_ID' attribute_name
923: ,p_TerrSrvTask_Rec.SQUAL_NUM17 num_value
924: ,null char_value
925: ,null date_value
926: FROM DUAL
927: UNION ALL
928: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
929: ,p_TerrSrvTask_Rec.SQUAL_NUM18 num_value
930: ,null char_value

Line 932: FROM DUAL

928: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
929: ,p_TerrSrvTask_Rec.SQUAL_NUM18 num_value
930: ,null char_value
931: ,null date_value
932: FROM DUAL
933: UNION ALL
934: SELECT 'SSI_ORG_ID' attribute_name
935: ,p_TerrSrvTask_Rec.SQUAL_NUM19 num_value
936: ,null char_value

Line 938: FROM DUAL

934: SELECT 'SSI_ORG_ID' attribute_name
935: ,p_TerrSrvTask_Rec.SQUAL_NUM19 num_value
936: ,null char_value
937: ,null date_value
938: FROM DUAL
939: );
940:
941: /*
942: lp_Rec.squal_num01 := jtf_terr_number_list(p_TerrSrvTask_Rec.party_id);