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

Line 105: from dual;

101: , l_description
102: , sysdate
103: , -3113
104: , -1002
105: from dual;
106:
107:
108: EXCEPTION
109: when FND_API.G_EXC_ERROR then

Line 422: FROM DUAL

418: ( SELECT 'COUNTRY' attribute_name
419: ,null num_value
420: ,p_TerrServReq_Rec.COUNTRY char_value
421: ,null date_value
422: FROM DUAL
423: UNION ALL
424: SELECT 'CITY' attribute_name
425: ,null num_value
426: ,p_TerrServReq_Rec.CITY char_value

Line 428: FROM DUAL

424: SELECT 'CITY' attribute_name
425: ,null num_value
426: ,p_TerrServReq_Rec.CITY char_value
427: ,null date_value
428: FROM DUAL
429: UNION ALL
430: SELECT 'POSTAL_CODE' attribute_name
431: ,null num_value
432: ,p_TerrServReq_Rec.POSTAL_CODE char_value

Line 434: FROM DUAL

430: SELECT 'POSTAL_CODE' attribute_name
431: ,null num_value
432: ,p_TerrServReq_Rec.POSTAL_CODE char_value
433: ,null date_value
434: FROM DUAL
435: UNION ALL
436: SELECT 'STATE' attribute_name
437: ,null num_value
438: ,p_TerrServReq_Rec.STATE char_value

Line 440: FROM DUAL

436: SELECT 'STATE' attribute_name
437: ,null num_value
438: ,p_TerrServReq_Rec.STATE char_value
439: ,null date_value
440: FROM DUAL
441: UNION ALL
442: SELECT 'AREA_CODE' attribute_name
443: ,null num_value
444: ,p_TerrServReq_Rec.AREA_CODE char_value

Line 446: FROM DUAL

442: SELECT 'AREA_CODE' attribute_name
443: ,null num_value
444: ,p_TerrServReq_Rec.AREA_CODE char_value
445: ,null date_value
446: FROM DUAL
447: UNION ALL
448: SELECT 'COUNTY' attribute_name
449: ,null num_value
450: ,p_TerrServReq_Rec.COUNTY char_value

Line 452: FROM DUAL

448: SELECT 'COUNTY' attribute_name
449: ,null num_value
450: ,p_TerrServReq_Rec.COUNTY char_value
451: ,null date_value
452: FROM DUAL
453: UNION ALL
454: SELECT 'COMP_NAME_RANGE' attribute_name
455: ,null num_value
456: ,p_TerrServReq_Rec.COMP_NAME_RANGE char_value

Line 458: FROM DUAL

454: SELECT 'COMP_NAME_RANGE' attribute_name
455: ,null num_value
456: ,p_TerrServReq_Rec.COMP_NAME_RANGE char_value
457: ,null date_value
458: FROM DUAL
459: UNION ALL
460: SELECT 'PROVINCE' attribute_name
461: ,null num_value
462: ,p_TerrServReq_Rec.PROVINCE char_value

Line 464: FROM DUAL

460: SELECT 'PROVINCE' attribute_name
461: ,null num_value
462: ,p_TerrServReq_Rec.PROVINCE char_value
463: ,null date_value
464: FROM DUAL
465: UNION ALL
466: SELECT 'PROBLEM_CODE' attribute_name
467: ,null num_value
468: ,p_TerrServReq_Rec.PROBLEM_CODE char_value

Line 470: FROM DUAL

466: SELECT 'PROBLEM_CODE' attribute_name
467: ,null num_value
468: ,p_TerrServReq_Rec.PROBLEM_CODE char_value
469: ,null date_value
470: FROM DUAL
471: UNION ALL
472: SELECT 'SR_CREATION_CHANNEL' attribute_name
473: ,null num_value
474: ,p_TerrServReq_Rec.SR_CREATION_CHANNEL char_value

Line 476: FROM DUAL

472: SELECT 'SR_CREATION_CHANNEL' attribute_name
473: ,null num_value
474: ,p_TerrServReq_Rec.SR_CREATION_CHANNEL char_value
475: ,null date_value
476: FROM DUAL
477: UNION ALL
478: SELECT 'VIP_CUSTOMER' attribute_name
479: ,null num_value
480: ,p_TerrServReq_Rec.squal_char11 char_value

Line 482: FROM DUAL

478: SELECT 'VIP_CUSTOMER' attribute_name
479: ,null num_value
480: ,p_TerrServReq_Rec.squal_char11 char_value
481: ,null date_value
482: FROM DUAL
483: UNION ALL
484: SELECT 'SR_PROBLEM_CODE' attribute_name
485: ,null num_value
486: ,p_TerrServReq_Rec.squal_char12 char_value

Line 488: FROM DUAL

484: SELECT 'SR_PROBLEM_CODE' attribute_name
485: ,null num_value
486: ,p_TerrServReq_Rec.squal_char12 char_value
487: ,null date_value
488: FROM DUAL
489: UNION ALL
490: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
491: ,null num_value
492: ,p_TerrServReq_Rec.squal_char13 char_value

Line 494: FROM DUAL

490: SELECT 'SR_CUST_CNTCT_PREF' attribute_name
491: ,null num_value
492: ,p_TerrServReq_Rec.squal_char13 char_value
493: ,null date_value
494: FROM DUAL
495: UNION ALL
496: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
497: ,null num_value
498: ,p_TerrServReq_Rec.squal_char21 char_value

Line 500: FROM DUAL

496: SELECT 'SR_SRVC_CNTCT_CVG' attribute_name
497: ,null num_value
498: ,p_TerrServReq_Rec.squal_char21 char_value
499: ,null date_value
500: FROM DUAL
501: UNION ALL
502: SELECT 'SR_LANGUAGE' attribute_name
503: ,null num_value
504: ,p_TerrServReq_Rec.squal_char20 char_value

Line 506: FROM DUAL

502: SELECT 'SR_LANGUAGE' attribute_name
503: ,null num_value
504: ,p_TerrServReq_Rec.squal_char20 char_value
505: ,null date_value
506: FROM DUAL
507: UNION ALL
508: SELECT 'PARTY_ID' attribute_name
509: ,p_TerrServReq_Rec.PARTY_ID num_value
510: ,null char_value

Line 512: FROM DUAL

508: SELECT 'PARTY_ID' attribute_name
509: ,p_TerrServReq_Rec.PARTY_ID num_value
510: ,null char_value
511: ,null date_value
512: FROM DUAL
513: UNION ALL
514: SELECT 'PARTY_SITE_ID' attribute_name
515: ,p_TerrServReq_Rec.PARTY_SITE_ID num_value
516: ,null char_value

Line 518: FROM DUAL

514: SELECT 'PARTY_SITE_ID' attribute_name
515: ,p_TerrServReq_Rec.PARTY_SITE_ID num_value
516: ,null char_value
517: ,null date_value
518: FROM DUAL
519: UNION ALL
520: SELECT 'NUM_OF_EMPLOYEES' attribute_name
521: ,p_TerrServReq_Rec.NUM_OF_EMPLOYEES num_value
522: ,null char_value

Line 524: FROM DUAL

520: SELECT 'NUM_OF_EMPLOYEES' attribute_name
521: ,p_TerrServReq_Rec.NUM_OF_EMPLOYEES num_value
522: ,null char_value
523: ,null date_value
524: FROM DUAL
525: UNION ALL
526: SELECT 'INCIDENT_TYPE_ID' attribute_name
527: ,p_TerrServReq_Rec.INCIDENT_TYPE_ID num_value
528: ,null char_value

Line 530: FROM DUAL

526: SELECT 'INCIDENT_TYPE_ID' attribute_name
527: ,p_TerrServReq_Rec.INCIDENT_TYPE_ID num_value
528: ,null char_value
529: ,null date_value
530: FROM DUAL
531: UNION ALL
532: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
533: ,p_TerrServReq_Rec.INCIDENT_SEVERITY_ID num_value
534: ,null char_value

Line 536: FROM DUAL

532: SELECT 'INCIDENT_SEVERITY_ID' attribute_name
533: ,p_TerrServReq_Rec.INCIDENT_SEVERITY_ID num_value
534: ,null char_value
535: ,null date_value
536: FROM DUAL
537: UNION ALL
538: SELECT 'INCIDENT_URGENCY_ID' attribute_name
539: ,p_TerrServReq_Rec.INCIDENT_URGENCY_ID num_value
540: ,null char_value

Line 542: FROM DUAL

538: SELECT 'INCIDENT_URGENCY_ID' attribute_name
539: ,p_TerrServReq_Rec.INCIDENT_URGENCY_ID num_value
540: ,null char_value
541: ,null date_value
542: FROM DUAL
543: UNION ALL
544: SELECT 'INCIDENT_STATUS_ID' attribute_name
545: ,p_TerrServReq_Rec.INCIDENT_STATUS_ID num_value
546: ,null char_value

Line 548: FROM DUAL

544: SELECT 'INCIDENT_STATUS_ID' attribute_name
545: ,p_TerrServReq_Rec.INCIDENT_STATUS_ID num_value
546: ,null char_value
547: ,null date_value
548: FROM DUAL
549: UNION ALL
550: SELECT 'PLATFORM_ID' attribute_name
551: ,p_TerrServReq_Rec.PLATFORM_ID num_value
552: ,null char_value

Line 554: FROM DUAL

550: SELECT 'PLATFORM_ID' attribute_name
551: ,p_TerrServReq_Rec.PLATFORM_ID num_value
552: ,null char_value
553: ,null date_value
554: FROM DUAL
555: UNION ALL
556: SELECT 'SUPPORT_SITE_ID' attribute_name
557: ,p_TerrServReq_Rec.SUPPORT_SITE_ID num_value
558: ,null char_value

Line 560: FROM DUAL

556: SELECT 'SUPPORT_SITE_ID' attribute_name
557: ,p_TerrServReq_Rec.SUPPORT_SITE_ID num_value
558: ,null char_value
559: ,null date_value
560: FROM DUAL
561: UNION ALL
562: SELECT 'CUSTOMER_SITE_ID' attribute_name
563: ,p_TerrServReq_Rec.CUSTOMER_SITE_ID num_value
564: ,null char_value

Line 566: FROM DUAL

562: SELECT 'CUSTOMER_SITE_ID' attribute_name
563: ,p_TerrServReq_Rec.CUSTOMER_SITE_ID num_value
564: ,null char_value
565: ,null date_value
566: FROM DUAL
567: UNION ALL
568: SELECT 'INVENTORY_ITEM_ID' attribute_name
569: ,p_TerrServReq_Rec.INVENTORY_ITEM_ID num_value
570: ,null char_value

Line 572: FROM DUAL

568: SELECT 'INVENTORY_ITEM_ID' attribute_name
569: ,p_TerrServReq_Rec.INVENTORY_ITEM_ID num_value
570: ,null char_value
571: ,null date_value
572: FROM DUAL
573: UNION ALL
574: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
575: ,p_TerrServReq_Rec.SQUAL_NUM12 num_value
576: ,null char_value

Line 578: FROM DUAL

574: SELECT 'SRP_INVENTORY_ITEM_ID' attribute_name
575: ,p_TerrServReq_Rec.SQUAL_NUM12 num_value
576: ,null char_value
577: ,null date_value
578: FROM DUAL
579: UNION ALL
580: SELECT 'SRP_ORG_ID' attribute_name
581: ,p_TerrServReq_Rec.SQUAL_NUM13 num_value
582: ,null char_value

Line 584: FROM DUAL

580: SELECT 'SRP_ORG_ID' attribute_name
581: ,p_TerrServReq_Rec.SQUAL_NUM13 num_value
582: ,null char_value
583: ,null date_value
584: FROM DUAL
585: UNION ALL
586: SELECT 'SPC_CATEGORY_ID' attribute_name
587: ,p_TerrServReq_Rec.SQUAL_NUM14 num_value
588: ,null char_value

Line 590: FROM DUAL

586: SELECT 'SPC_CATEGORY_ID' attribute_name
587: ,p_TerrServReq_Rec.SQUAL_NUM14 num_value
588: ,null char_value
589: ,null date_value
590: FROM DUAL
591: UNION ALL
592: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
593: ,p_TerrServReq_Rec.SQUAL_NUM15 num_value
594: ,null char_value

Line 596: FROM DUAL

592: SELECT 'PCS_INVENTORY_ITEM_ID' attribute_name
593: ,p_TerrServReq_Rec.SQUAL_NUM15 num_value
594: ,null char_value
595: ,null date_value
596: FROM DUAL
597: UNION ALL
598: SELECT 'PCS_ORG_ID' attribute_name
599: ,p_TerrServReq_Rec.SQUAL_NUM16 num_value
600: ,null char_value

Line 602: FROM DUAL

598: SELECT 'PCS_ORG_ID' attribute_name
599: ,p_TerrServReq_Rec.SQUAL_NUM16 num_value
600: ,null char_value
601: ,null date_value
602: FROM DUAL
603: UNION ALL
604: SELECT 'PCS_COMPONENT_ID' attribute_name
605: ,p_TerrServReq_Rec.SQUAL_NUM23 num_value
606: ,null char_value

Line 608: FROM DUAL

604: SELECT 'PCS_COMPONENT_ID' attribute_name
605: ,p_TerrServReq_Rec.SQUAL_NUM23 num_value
606: ,null char_value
607: ,null date_value
608: FROM DUAL
609: UNION ALL
610: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
611: ,p_TerrServReq_Rec.SQUAL_NUM24 num_value
612: ,null char_value

Line 614: FROM DUAL

610: SELECT 'PCS_SUBCOMPONENT_ID' attribute_name
611: ,p_TerrServReq_Rec.SQUAL_NUM24 num_value
612: ,null char_value
613: ,null date_value
614: FROM DUAL
615: UNION ALL
616: SELECT 'SR_GROUP_OWNER_ID' attribute_name
617: ,p_TerrServReq_Rec.SQUAL_NUM17 num_value
618: ,null char_value

Line 620: FROM DUAL

616: SELECT 'SR_GROUP_OWNER_ID' attribute_name
617: ,p_TerrServReq_Rec.SQUAL_NUM17 num_value
618: ,null char_value
619: ,null date_value
620: FROM DUAL
621: UNION ALL
622: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
623: ,p_TerrServReq_Rec.SQUAL_NUM18 num_value
624: ,null char_value

Line 626: FROM DUAL

622: SELECT 'SSI_INVENTORY_ITEM_ID' attribute_name
623: ,p_TerrServReq_Rec.SQUAL_NUM18 num_value
624: ,null char_value
625: ,null date_value
626: FROM DUAL
627: UNION ALL
628: SELECT 'SSI_ORG_ID' attribute_name
629: ,p_TerrServReq_Rec.SQUAL_NUM19 num_value
630: ,null char_value

Line 632: FROM DUAL

628: SELECT 'SSI_ORG_ID' attribute_name
629: ,p_TerrServReq_Rec.SQUAL_NUM19 num_value
630: ,null char_value
631: ,null date_value
632: FROM DUAL
633: UNION ALL
634: SELECT 'DAY_OF_WEEK' attribute_name
635: ,null num_value
636: --,p_TerrServReq_Rec.DAY_OF_WEEK char_value

Line 640: FROM DUAL

636: --,p_TerrServReq_Rec.DAY_OF_WEEK char_value
637: , DECODE(p_TerrServReq_Rec.DAY_OF_WEEK,FND_API.G_MISS_CHAR,null,
638: p_TerrServReq_Rec.DAY_OF_WEEK) char_value
639: ,null date_value
640: FROM DUAL
641: UNION ALL
642: SELECT 'TIME_OF_DAY' attribute_name
643: , null num_value
644: --, p_TerrServReq_Rec.TIME_OF_DAY char_value

Line 648: FROM DUAL

644: --, p_TerrServReq_Rec.TIME_OF_DAY char_value
645: , DECODE(p_TerrServReq_Rec.TIME_OF_DAY,FND_API.G_MISS_CHAR,null,
646: p_TerrServReq_Rec.TIME_OF_DAY) char_value
647: ,null date_value
648: FROM DUAL
649:
650: );
651:
652: