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.POA_PORTAL_POPULATE_C dependencies on POA_PORTAL_SUP_RISK_IND

Line 622: POA_PORTAL_SUP_RISK_IND.get_range1_low(1),

618: Purchase_Amount)
619: select 'Problem Suppliers', 1,
620: Supplier.tprt_trade_partner_pk_key,
621: Supplier.tprt_name,
622: POA_PORTAL_SUP_RISK_IND.get_range1_low(1),
623: POA_PORTAL_SUP_RISK_IND.get_range1_high(1),
624: POA_PORTAL_SUP_RISK_IND.get_range1_low(2),
625: POA_PORTAL_SUP_RISK_IND.get_range1_high(2),
626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),

Line 623: POA_PORTAL_SUP_RISK_IND.get_range1_high(1),

619: select 'Problem Suppliers', 1,
620: Supplier.tprt_trade_partner_pk_key,
621: Supplier.tprt_name,
622: POA_PORTAL_SUP_RISK_IND.get_range1_low(1),
623: POA_PORTAL_SUP_RISK_IND.get_range1_high(1),
624: POA_PORTAL_SUP_RISK_IND.get_range1_low(2),
625: POA_PORTAL_SUP_RISK_IND.get_range1_high(2),
626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),
627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),

Line 624: POA_PORTAL_SUP_RISK_IND.get_range1_low(2),

620: Supplier.tprt_trade_partner_pk_key,
621: Supplier.tprt_name,
622: POA_PORTAL_SUP_RISK_IND.get_range1_low(1),
623: POA_PORTAL_SUP_RISK_IND.get_range1_high(1),
624: POA_PORTAL_SUP_RISK_IND.get_range1_low(2),
625: POA_PORTAL_SUP_RISK_IND.get_range1_high(2),
626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),
627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),
628: POA_PORTAL_SUP_RISK_IND.get_range1_low(4),

Line 625: POA_PORTAL_SUP_RISK_IND.get_range1_high(2),

621: Supplier.tprt_name,
622: POA_PORTAL_SUP_RISK_IND.get_range1_low(1),
623: POA_PORTAL_SUP_RISK_IND.get_range1_high(1),
624: POA_PORTAL_SUP_RISK_IND.get_range1_low(2),
625: POA_PORTAL_SUP_RISK_IND.get_range1_high(2),
626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),
627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),
628: POA_PORTAL_SUP_RISK_IND.get_range1_low(4),
629: POA_PORTAL_SUP_RISK_IND.get_range1_high(4),

Line 626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),

622: POA_PORTAL_SUP_RISK_IND.get_range1_low(1),
623: POA_PORTAL_SUP_RISK_IND.get_range1_high(1),
624: POA_PORTAL_SUP_RISK_IND.get_range1_low(2),
625: POA_PORTAL_SUP_RISK_IND.get_range1_high(2),
626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),
627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),
628: POA_PORTAL_SUP_RISK_IND.get_range1_low(4),
629: POA_PORTAL_SUP_RISK_IND.get_range1_high(4),
630: POA_PORTAL_SUP_RISK_IND.get_range1_low(5),

Line 627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),

623: POA_PORTAL_SUP_RISK_IND.get_range1_high(1),
624: POA_PORTAL_SUP_RISK_IND.get_range1_low(2),
625: POA_PORTAL_SUP_RISK_IND.get_range1_high(2),
626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),
627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),
628: POA_PORTAL_SUP_RISK_IND.get_range1_low(4),
629: POA_PORTAL_SUP_RISK_IND.get_range1_high(4),
630: POA_PORTAL_SUP_RISK_IND.get_range1_low(5),
631: POA_PORTAL_SUP_RISK_IND.get_range1_high(5),

Line 628: POA_PORTAL_SUP_RISK_IND.get_range1_low(4),

624: POA_PORTAL_SUP_RISK_IND.get_range1_low(2),
625: POA_PORTAL_SUP_RISK_IND.get_range1_high(2),
626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),
627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),
628: POA_PORTAL_SUP_RISK_IND.get_range1_low(4),
629: POA_PORTAL_SUP_RISK_IND.get_range1_high(4),
630: POA_PORTAL_SUP_RISK_IND.get_range1_low(5),
631: POA_PORTAL_SUP_RISK_IND.get_range1_high(5),
632: decode(sign(round(avg(Total_Score)) -

Line 629: POA_PORTAL_SUP_RISK_IND.get_range1_high(4),

625: POA_PORTAL_SUP_RISK_IND.get_range1_high(2),
626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),
627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),
628: POA_PORTAL_SUP_RISK_IND.get_range1_low(4),
629: POA_PORTAL_SUP_RISK_IND.get_range1_high(4),
630: POA_PORTAL_SUP_RISK_IND.get_range1_low(5),
631: POA_PORTAL_SUP_RISK_IND.get_range1_high(5),
632: decode(sign(round(avg(Total_Score)) -
633: POA_PORTAL_SUP_RISK_IND.get_range1_low(1)),

Line 630: POA_PORTAL_SUP_RISK_IND.get_range1_low(5),

626: POA_PORTAL_SUP_RISK_IND.get_range1_low(3),
627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),
628: POA_PORTAL_SUP_RISK_IND.get_range1_low(4),
629: POA_PORTAL_SUP_RISK_IND.get_range1_high(4),
630: POA_PORTAL_SUP_RISK_IND.get_range1_low(5),
631: POA_PORTAL_SUP_RISK_IND.get_range1_high(5),
632: decode(sign(round(avg(Total_Score)) -
633: POA_PORTAL_SUP_RISK_IND.get_range1_low(1)),
634: -1,-999,

Line 631: POA_PORTAL_SUP_RISK_IND.get_range1_high(5),

627: POA_PORTAL_SUP_RISK_IND.get_range1_high(3),
628: POA_PORTAL_SUP_RISK_IND.get_range1_low(4),
629: POA_PORTAL_SUP_RISK_IND.get_range1_high(4),
630: POA_PORTAL_SUP_RISK_IND.get_range1_low(5),
631: POA_PORTAL_SUP_RISK_IND.get_range1_high(5),
632: decode(sign(round(avg(Total_Score)) -
633: POA_PORTAL_SUP_RISK_IND.get_range1_low(1)),
634: -1,-999,
635: 0, avg(Total_Score),

Line 633: POA_PORTAL_SUP_RISK_IND.get_range1_low(1)),

629: POA_PORTAL_SUP_RISK_IND.get_range1_high(4),
630: POA_PORTAL_SUP_RISK_IND.get_range1_low(5),
631: POA_PORTAL_SUP_RISK_IND.get_range1_high(5),
632: decode(sign(round(avg(Total_Score)) -
633: POA_PORTAL_SUP_RISK_IND.get_range1_low(1)),
634: -1,-999,
635: 0, avg(Total_Score),
636: 1, decode(sign(round(avg(Total_Score)) -
637: POA_PORTAL_SUP_RISK_IND.get_range1_high(1)),

Line 637: POA_PORTAL_SUP_RISK_IND.get_range1_high(1)),

633: POA_PORTAL_SUP_RISK_IND.get_range1_low(1)),
634: -1,-999,
635: 0, avg(Total_Score),
636: 1, decode(sign(round(avg(Total_Score)) -
637: POA_PORTAL_SUP_RISK_IND.get_range1_high(1)),
638: -1, avg(Total_Score),
639: 0, avg(Total_Score), -999)),
640: decode(sign(round(avg(Price_Score)) -
641: POA_PORTAL_SUP_RISK_IND.get_range1_low(2)),

Line 641: POA_PORTAL_SUP_RISK_IND.get_range1_low(2)),

637: POA_PORTAL_SUP_RISK_IND.get_range1_high(1)),
638: -1, avg(Total_Score),
639: 0, avg(Total_Score), -999)),
640: decode(sign(round(avg(Price_Score)) -
641: POA_PORTAL_SUP_RISK_IND.get_range1_low(2)),
642: -1,-999,
643: 0, avg(Price_Score),
644: 1, decode(sign(round(avg(Price_Score)) -
645: POA_PORTAL_SUP_RISK_IND.get_range1_high(2)),

Line 645: POA_PORTAL_SUP_RISK_IND.get_range1_high(2)),

641: POA_PORTAL_SUP_RISK_IND.get_range1_low(2)),
642: -1,-999,
643: 0, avg(Price_Score),
644: 1, decode(sign(round(avg(Price_Score)) -
645: POA_PORTAL_SUP_RISK_IND.get_range1_high(2)),
646: -1, avg(Price_Score),
647: 0, avg(Price_Score), -999)),
648: decode(sign(round(avg(Quality_Score)) -
649: POA_PORTAL_SUP_RISK_IND.get_range1_low(3)),

Line 649: POA_PORTAL_SUP_RISK_IND.get_range1_low(3)),

645: POA_PORTAL_SUP_RISK_IND.get_range1_high(2)),
646: -1, avg(Price_Score),
647: 0, avg(Price_Score), -999)),
648: decode(sign(round(avg(Quality_Score)) -
649: POA_PORTAL_SUP_RISK_IND.get_range1_low(3)),
650: -1,-999,
651: 0, avg(Quality_Score),
652: 1, decode(sign(round(avg(Quality_Score)) -
653: POA_PORTAL_SUP_RISK_IND.get_range1_high(3)),

Line 653: POA_PORTAL_SUP_RISK_IND.get_range1_high(3)),

649: POA_PORTAL_SUP_RISK_IND.get_range1_low(3)),
650: -1,-999,
651: 0, avg(Quality_Score),
652: 1, decode(sign(round(avg(Quality_Score)) -
653: POA_PORTAL_SUP_RISK_IND.get_range1_high(3)),
654: -1, avg(Quality_Score),
655: 0, avg(Quality_Score), -999)),
656: decode(sign(round(avg(Delivery_Score)) -
657: POA_PORTAL_SUP_RISK_IND.get_range1_low(4)),

Line 657: POA_PORTAL_SUP_RISK_IND.get_range1_low(4)),

653: POA_PORTAL_SUP_RISK_IND.get_range1_high(3)),
654: -1, avg(Quality_Score),
655: 0, avg(Quality_Score), -999)),
656: decode(sign(round(avg(Delivery_Score)) -
657: POA_PORTAL_SUP_RISK_IND.get_range1_low(4)),
658: -1,-999,
659: 0, avg(Delivery_Score),
660: 1, decode(sign(round(avg(Delivery_Score)) -
661: POA_PORTAL_SUP_RISK_IND.get_range1_high(4)),

Line 661: POA_PORTAL_SUP_RISK_IND.get_range1_high(4)),

657: POA_PORTAL_SUP_RISK_IND.get_range1_low(4)),
658: -1,-999,
659: 0, avg(Delivery_Score),
660: 1, decode(sign(round(avg(Delivery_Score)) -
661: POA_PORTAL_SUP_RISK_IND.get_range1_high(4)),
662: -1, avg(Delivery_Score),
663: 0, avg(Delivery_Score), -999)),
664: decode(sign(round(avg(Survey_Score)) -
665: POA_PORTAL_SUP_RISK_IND.get_range1_low(5)),

Line 665: POA_PORTAL_SUP_RISK_IND.get_range1_low(5)),

661: POA_PORTAL_SUP_RISK_IND.get_range1_high(4)),
662: -1, avg(Delivery_Score),
663: 0, avg(Delivery_Score), -999)),
664: decode(sign(round(avg(Survey_Score)) -
665: POA_PORTAL_SUP_RISK_IND.get_range1_low(5)),
666: -1,-999,
667: 0, avg(Survey_Score),
668: 1, decode(sign(round(avg(Survey_Score)) -
669: POA_PORTAL_SUP_RISK_IND.get_range1_high(5)),

Line 669: POA_PORTAL_SUP_RISK_IND.get_range1_high(5)),

665: POA_PORTAL_SUP_RISK_IND.get_range1_low(5)),
666: -1,-999,
667: 0, avg(Survey_Score),
668: 1, decode(sign(round(avg(Survey_Score)) -
669: POA_PORTAL_SUP_RISK_IND.get_range1_high(5)),
670: -1, avg(Survey_Score),
671: 0, avg(Survey_Score), -999)),
672: sum(pod.amt_purchased_g)
673: from poa_edw_po_dist_f pod,

Line 717: POA_PORTAL_SUP_RISK_IND.get_range2_low(1),

713: Purchase_Amount)
714: select 'At Risk Suppliers', 2,
715: Supplier.tprt_trade_partner_pk_key,
716: Supplier.tprt_name,
717: POA_PORTAL_SUP_RISK_IND.get_range2_low(1),
718: POA_PORTAL_SUP_RISK_IND.get_range2_high(1),
719: POA_PORTAL_SUP_RISK_IND.get_range2_low(2),
720: POA_PORTAL_SUP_RISK_IND.get_range2_high(2),
721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),

Line 718: POA_PORTAL_SUP_RISK_IND.get_range2_high(1),

714: select 'At Risk Suppliers', 2,
715: Supplier.tprt_trade_partner_pk_key,
716: Supplier.tprt_name,
717: POA_PORTAL_SUP_RISK_IND.get_range2_low(1),
718: POA_PORTAL_SUP_RISK_IND.get_range2_high(1),
719: POA_PORTAL_SUP_RISK_IND.get_range2_low(2),
720: POA_PORTAL_SUP_RISK_IND.get_range2_high(2),
721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),
722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),

Line 719: POA_PORTAL_SUP_RISK_IND.get_range2_low(2),

715: Supplier.tprt_trade_partner_pk_key,
716: Supplier.tprt_name,
717: POA_PORTAL_SUP_RISK_IND.get_range2_low(1),
718: POA_PORTAL_SUP_RISK_IND.get_range2_high(1),
719: POA_PORTAL_SUP_RISK_IND.get_range2_low(2),
720: POA_PORTAL_SUP_RISK_IND.get_range2_high(2),
721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),
722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),
723: POA_PORTAL_SUP_RISK_IND.get_range2_low(4),

Line 720: POA_PORTAL_SUP_RISK_IND.get_range2_high(2),

716: Supplier.tprt_name,
717: POA_PORTAL_SUP_RISK_IND.get_range2_low(1),
718: POA_PORTAL_SUP_RISK_IND.get_range2_high(1),
719: POA_PORTAL_SUP_RISK_IND.get_range2_low(2),
720: POA_PORTAL_SUP_RISK_IND.get_range2_high(2),
721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),
722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),
723: POA_PORTAL_SUP_RISK_IND.get_range2_low(4),
724: POA_PORTAL_SUP_RISK_IND.get_range2_high(4),

Line 721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),

717: POA_PORTAL_SUP_RISK_IND.get_range2_low(1),
718: POA_PORTAL_SUP_RISK_IND.get_range2_high(1),
719: POA_PORTAL_SUP_RISK_IND.get_range2_low(2),
720: POA_PORTAL_SUP_RISK_IND.get_range2_high(2),
721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),
722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),
723: POA_PORTAL_SUP_RISK_IND.get_range2_low(4),
724: POA_PORTAL_SUP_RISK_IND.get_range2_high(4),
725: POA_PORTAL_SUP_RISK_IND.get_range2_low(5),

Line 722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),

718: POA_PORTAL_SUP_RISK_IND.get_range2_high(1),
719: POA_PORTAL_SUP_RISK_IND.get_range2_low(2),
720: POA_PORTAL_SUP_RISK_IND.get_range2_high(2),
721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),
722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),
723: POA_PORTAL_SUP_RISK_IND.get_range2_low(4),
724: POA_PORTAL_SUP_RISK_IND.get_range2_high(4),
725: POA_PORTAL_SUP_RISK_IND.get_range2_low(5),
726: POA_PORTAL_SUP_RISK_IND.get_range2_high(5),

Line 723: POA_PORTAL_SUP_RISK_IND.get_range2_low(4),

719: POA_PORTAL_SUP_RISK_IND.get_range2_low(2),
720: POA_PORTAL_SUP_RISK_IND.get_range2_high(2),
721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),
722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),
723: POA_PORTAL_SUP_RISK_IND.get_range2_low(4),
724: POA_PORTAL_SUP_RISK_IND.get_range2_high(4),
725: POA_PORTAL_SUP_RISK_IND.get_range2_low(5),
726: POA_PORTAL_SUP_RISK_IND.get_range2_high(5),
727: decode(sign(round(avg(Total_Score)) -

Line 724: POA_PORTAL_SUP_RISK_IND.get_range2_high(4),

720: POA_PORTAL_SUP_RISK_IND.get_range2_high(2),
721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),
722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),
723: POA_PORTAL_SUP_RISK_IND.get_range2_low(4),
724: POA_PORTAL_SUP_RISK_IND.get_range2_high(4),
725: POA_PORTAL_SUP_RISK_IND.get_range2_low(5),
726: POA_PORTAL_SUP_RISK_IND.get_range2_high(5),
727: decode(sign(round(avg(Total_Score)) -
728: POA_PORTAL_SUP_RISK_IND.get_range2_low(1)),

Line 725: POA_PORTAL_SUP_RISK_IND.get_range2_low(5),

721: POA_PORTAL_SUP_RISK_IND.get_range2_low(3),
722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),
723: POA_PORTAL_SUP_RISK_IND.get_range2_low(4),
724: POA_PORTAL_SUP_RISK_IND.get_range2_high(4),
725: POA_PORTAL_SUP_RISK_IND.get_range2_low(5),
726: POA_PORTAL_SUP_RISK_IND.get_range2_high(5),
727: decode(sign(round(avg(Total_Score)) -
728: POA_PORTAL_SUP_RISK_IND.get_range2_low(1)),
729: -1,-999,

Line 726: POA_PORTAL_SUP_RISK_IND.get_range2_high(5),

722: POA_PORTAL_SUP_RISK_IND.get_range2_high(3),
723: POA_PORTAL_SUP_RISK_IND.get_range2_low(4),
724: POA_PORTAL_SUP_RISK_IND.get_range2_high(4),
725: POA_PORTAL_SUP_RISK_IND.get_range2_low(5),
726: POA_PORTAL_SUP_RISK_IND.get_range2_high(5),
727: decode(sign(round(avg(Total_Score)) -
728: POA_PORTAL_SUP_RISK_IND.get_range2_low(1)),
729: -1,-999,
730: 0, avg(Total_Score),

Line 728: POA_PORTAL_SUP_RISK_IND.get_range2_low(1)),

724: POA_PORTAL_SUP_RISK_IND.get_range2_high(4),
725: POA_PORTAL_SUP_RISK_IND.get_range2_low(5),
726: POA_PORTAL_SUP_RISK_IND.get_range2_high(5),
727: decode(sign(round(avg(Total_Score)) -
728: POA_PORTAL_SUP_RISK_IND.get_range2_low(1)),
729: -1,-999,
730: 0, avg(Total_Score),
731: 1, decode(sign(round(avg(Total_Score)) -
732: POA_PORTAL_SUP_RISK_IND.get_range2_high(1)),

Line 732: POA_PORTAL_SUP_RISK_IND.get_range2_high(1)),

728: POA_PORTAL_SUP_RISK_IND.get_range2_low(1)),
729: -1,-999,
730: 0, avg(Total_Score),
731: 1, decode(sign(round(avg(Total_Score)) -
732: POA_PORTAL_SUP_RISK_IND.get_range2_high(1)),
733: -1, avg(Total_Score),
734: 0, avg(Total_Score), -999)),
735: decode(sign(round(avg(Price_Score)) -
736: POA_PORTAL_SUP_RISK_IND.get_range2_low(2)),

Line 736: POA_PORTAL_SUP_RISK_IND.get_range2_low(2)),

732: POA_PORTAL_SUP_RISK_IND.get_range2_high(1)),
733: -1, avg(Total_Score),
734: 0, avg(Total_Score), -999)),
735: decode(sign(round(avg(Price_Score)) -
736: POA_PORTAL_SUP_RISK_IND.get_range2_low(2)),
737: -1,-999,
738: 0, avg(Price_Score),
739: 1, decode(sign(round(avg(Price_Score)) -
740: POA_PORTAL_SUP_RISK_IND.get_range2_high(2)),

Line 740: POA_PORTAL_SUP_RISK_IND.get_range2_high(2)),

736: POA_PORTAL_SUP_RISK_IND.get_range2_low(2)),
737: -1,-999,
738: 0, avg(Price_Score),
739: 1, decode(sign(round(avg(Price_Score)) -
740: POA_PORTAL_SUP_RISK_IND.get_range2_high(2)),
741: -1, avg(Price_Score),
742: 0, avg(Price_Score), -999)),
743: decode(sign(round(avg(Quality_Score)) -
744: POA_PORTAL_SUP_RISK_IND.get_range2_low(3)),

Line 744: POA_PORTAL_SUP_RISK_IND.get_range2_low(3)),

740: POA_PORTAL_SUP_RISK_IND.get_range2_high(2)),
741: -1, avg(Price_Score),
742: 0, avg(Price_Score), -999)),
743: decode(sign(round(avg(Quality_Score)) -
744: POA_PORTAL_SUP_RISK_IND.get_range2_low(3)),
745: -1,-999,
746: 0, avg(Quality_Score),
747: 1, decode(sign(round(avg(Quality_Score)) -
748: POA_PORTAL_SUP_RISK_IND.get_range2_high(3)),

Line 748: POA_PORTAL_SUP_RISK_IND.get_range2_high(3)),

744: POA_PORTAL_SUP_RISK_IND.get_range2_low(3)),
745: -1,-999,
746: 0, avg(Quality_Score),
747: 1, decode(sign(round(avg(Quality_Score)) -
748: POA_PORTAL_SUP_RISK_IND.get_range2_high(3)),
749: -1, avg(Quality_Score),
750: 0, avg(Quality_Score), -999)),
751: decode(sign(round(avg(Delivery_Score)) -
752: POA_PORTAL_SUP_RISK_IND.get_range2_low(4)),

Line 752: POA_PORTAL_SUP_RISK_IND.get_range2_low(4)),

748: POA_PORTAL_SUP_RISK_IND.get_range2_high(3)),
749: -1, avg(Quality_Score),
750: 0, avg(Quality_Score), -999)),
751: decode(sign(round(avg(Delivery_Score)) -
752: POA_PORTAL_SUP_RISK_IND.get_range2_low(4)),
753: -1,-999,
754: 0, avg(Delivery_Score),
755: 1, decode(sign(round(avg(Delivery_Score)) -
756: POA_PORTAL_SUP_RISK_IND.get_range2_high(4)),

Line 756: POA_PORTAL_SUP_RISK_IND.get_range2_high(4)),

752: POA_PORTAL_SUP_RISK_IND.get_range2_low(4)),
753: -1,-999,
754: 0, avg(Delivery_Score),
755: 1, decode(sign(round(avg(Delivery_Score)) -
756: POA_PORTAL_SUP_RISK_IND.get_range2_high(4)),
757: -1, avg(Delivery_Score),
758: 0, avg(Delivery_Score), -999)),
759: decode(sign(round(avg(Survey_Score)) -
760: POA_PORTAL_SUP_RISK_IND.get_range2_low(5)),

Line 760: POA_PORTAL_SUP_RISK_IND.get_range2_low(5)),

756: POA_PORTAL_SUP_RISK_IND.get_range2_high(4)),
757: -1, avg(Delivery_Score),
758: 0, avg(Delivery_Score), -999)),
759: decode(sign(round(avg(Survey_Score)) -
760: POA_PORTAL_SUP_RISK_IND.get_range2_low(5)),
761: -1,-999,
762: 0, avg(Survey_Score),
763: 1, decode(sign(round(avg(Survey_Score)) -
764: POA_PORTAL_SUP_RISK_IND.get_range2_high(5)),

Line 764: POA_PORTAL_SUP_RISK_IND.get_range2_high(5)),

760: POA_PORTAL_SUP_RISK_IND.get_range2_low(5)),
761: -1,-999,
762: 0, avg(Survey_Score),
763: 1, decode(sign(round(avg(Survey_Score)) -
764: POA_PORTAL_SUP_RISK_IND.get_range2_high(5)),
765: -1, avg(Survey_Score),
766: 0, avg(Survey_Score), -999)),
767: sum(pod.amt_purchased_g)
768: from poa_edw_po_dist_f pod,

Line 812: POA_PORTAL_SUP_RISK_IND.get_range3_low(1),

808: Purchase_Amount)
809: select 'Good Suppliers', 3,
810: Supplier.tprt_trade_partner_pk_key,
811: Supplier.tprt_name,
812: POA_PORTAL_SUP_RISK_IND.get_range3_low(1),
813: POA_PORTAL_SUP_RISK_IND.get_range3_high(1),
814: POA_PORTAL_SUP_RISK_IND.get_range3_low(2),
815: POA_PORTAL_SUP_RISK_IND.get_range3_high(2),
816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),

Line 813: POA_PORTAL_SUP_RISK_IND.get_range3_high(1),

809: select 'Good Suppliers', 3,
810: Supplier.tprt_trade_partner_pk_key,
811: Supplier.tprt_name,
812: POA_PORTAL_SUP_RISK_IND.get_range3_low(1),
813: POA_PORTAL_SUP_RISK_IND.get_range3_high(1),
814: POA_PORTAL_SUP_RISK_IND.get_range3_low(2),
815: POA_PORTAL_SUP_RISK_IND.get_range3_high(2),
816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),
817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),

Line 814: POA_PORTAL_SUP_RISK_IND.get_range3_low(2),

810: Supplier.tprt_trade_partner_pk_key,
811: Supplier.tprt_name,
812: POA_PORTAL_SUP_RISK_IND.get_range3_low(1),
813: POA_PORTAL_SUP_RISK_IND.get_range3_high(1),
814: POA_PORTAL_SUP_RISK_IND.get_range3_low(2),
815: POA_PORTAL_SUP_RISK_IND.get_range3_high(2),
816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),
817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),
818: POA_PORTAL_SUP_RISK_IND.get_range3_low(4),

Line 815: POA_PORTAL_SUP_RISK_IND.get_range3_high(2),

811: Supplier.tprt_name,
812: POA_PORTAL_SUP_RISK_IND.get_range3_low(1),
813: POA_PORTAL_SUP_RISK_IND.get_range3_high(1),
814: POA_PORTAL_SUP_RISK_IND.get_range3_low(2),
815: POA_PORTAL_SUP_RISK_IND.get_range3_high(2),
816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),
817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),
818: POA_PORTAL_SUP_RISK_IND.get_range3_low(4),
819: POA_PORTAL_SUP_RISK_IND.get_range3_high(4),

Line 816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),

812: POA_PORTAL_SUP_RISK_IND.get_range3_low(1),
813: POA_PORTAL_SUP_RISK_IND.get_range3_high(1),
814: POA_PORTAL_SUP_RISK_IND.get_range3_low(2),
815: POA_PORTAL_SUP_RISK_IND.get_range3_high(2),
816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),
817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),
818: POA_PORTAL_SUP_RISK_IND.get_range3_low(4),
819: POA_PORTAL_SUP_RISK_IND.get_range3_high(4),
820: POA_PORTAL_SUP_RISK_IND.get_range3_low(5),

Line 817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),

813: POA_PORTAL_SUP_RISK_IND.get_range3_high(1),
814: POA_PORTAL_SUP_RISK_IND.get_range3_low(2),
815: POA_PORTAL_SUP_RISK_IND.get_range3_high(2),
816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),
817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),
818: POA_PORTAL_SUP_RISK_IND.get_range3_low(4),
819: POA_PORTAL_SUP_RISK_IND.get_range3_high(4),
820: POA_PORTAL_SUP_RISK_IND.get_range3_low(5),
821: POA_PORTAL_SUP_RISK_IND.get_range3_high(5),

Line 818: POA_PORTAL_SUP_RISK_IND.get_range3_low(4),

814: POA_PORTAL_SUP_RISK_IND.get_range3_low(2),
815: POA_PORTAL_SUP_RISK_IND.get_range3_high(2),
816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),
817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),
818: POA_PORTAL_SUP_RISK_IND.get_range3_low(4),
819: POA_PORTAL_SUP_RISK_IND.get_range3_high(4),
820: POA_PORTAL_SUP_RISK_IND.get_range3_low(5),
821: POA_PORTAL_SUP_RISK_IND.get_range3_high(5),
822: decode(sign(round(avg(Total_Score)) -

Line 819: POA_PORTAL_SUP_RISK_IND.get_range3_high(4),

815: POA_PORTAL_SUP_RISK_IND.get_range3_high(2),
816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),
817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),
818: POA_PORTAL_SUP_RISK_IND.get_range3_low(4),
819: POA_PORTAL_SUP_RISK_IND.get_range3_high(4),
820: POA_PORTAL_SUP_RISK_IND.get_range3_low(5),
821: POA_PORTAL_SUP_RISK_IND.get_range3_high(5),
822: decode(sign(round(avg(Total_Score)) -
823: POA_PORTAL_SUP_RISK_IND.get_range3_low(1)),

Line 820: POA_PORTAL_SUP_RISK_IND.get_range3_low(5),

816: POA_PORTAL_SUP_RISK_IND.get_range3_low(3),
817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),
818: POA_PORTAL_SUP_RISK_IND.get_range3_low(4),
819: POA_PORTAL_SUP_RISK_IND.get_range3_high(4),
820: POA_PORTAL_SUP_RISK_IND.get_range3_low(5),
821: POA_PORTAL_SUP_RISK_IND.get_range3_high(5),
822: decode(sign(round(avg(Total_Score)) -
823: POA_PORTAL_SUP_RISK_IND.get_range3_low(1)),
824: -1,-999,

Line 821: POA_PORTAL_SUP_RISK_IND.get_range3_high(5),

817: POA_PORTAL_SUP_RISK_IND.get_range3_high(3),
818: POA_PORTAL_SUP_RISK_IND.get_range3_low(4),
819: POA_PORTAL_SUP_RISK_IND.get_range3_high(4),
820: POA_PORTAL_SUP_RISK_IND.get_range3_low(5),
821: POA_PORTAL_SUP_RISK_IND.get_range3_high(5),
822: decode(sign(round(avg(Total_Score)) -
823: POA_PORTAL_SUP_RISK_IND.get_range3_low(1)),
824: -1,-999,
825: 0, avg(Total_Score),

Line 823: POA_PORTAL_SUP_RISK_IND.get_range3_low(1)),

819: POA_PORTAL_SUP_RISK_IND.get_range3_high(4),
820: POA_PORTAL_SUP_RISK_IND.get_range3_low(5),
821: POA_PORTAL_SUP_RISK_IND.get_range3_high(5),
822: decode(sign(round(avg(Total_Score)) -
823: POA_PORTAL_SUP_RISK_IND.get_range3_low(1)),
824: -1,-999,
825: 0, avg(Total_Score),
826: 1, decode(sign(round(avg(Total_Score)) -
827: POA_PORTAL_SUP_RISK_IND.get_range3_high(1)),

Line 827: POA_PORTAL_SUP_RISK_IND.get_range3_high(1)),

823: POA_PORTAL_SUP_RISK_IND.get_range3_low(1)),
824: -1,-999,
825: 0, avg(Total_Score),
826: 1, decode(sign(round(avg(Total_Score)) -
827: POA_PORTAL_SUP_RISK_IND.get_range3_high(1)),
828: -1, avg(Total_Score),
829: 0, avg(Total_Score), -999)),
830: decode(sign(round(avg(Price_Score)) -
831: POA_PORTAL_SUP_RISK_IND.get_range3_low(2)),

Line 831: POA_PORTAL_SUP_RISK_IND.get_range3_low(2)),

827: POA_PORTAL_SUP_RISK_IND.get_range3_high(1)),
828: -1, avg(Total_Score),
829: 0, avg(Total_Score), -999)),
830: decode(sign(round(avg(Price_Score)) -
831: POA_PORTAL_SUP_RISK_IND.get_range3_low(2)),
832: -1,-999,
833: 0, avg(Price_Score),
834: 1, decode(sign(round(avg(Price_Score)) -
835: POA_PORTAL_SUP_RISK_IND.get_range3_high(2)),

Line 835: POA_PORTAL_SUP_RISK_IND.get_range3_high(2)),

831: POA_PORTAL_SUP_RISK_IND.get_range3_low(2)),
832: -1,-999,
833: 0, avg(Price_Score),
834: 1, decode(sign(round(avg(Price_Score)) -
835: POA_PORTAL_SUP_RISK_IND.get_range3_high(2)),
836: -1, avg(Price_Score),
837: 0, avg(Price_Score), -999)),
838: decode(sign(round(avg(Quality_Score)) -
839: POA_PORTAL_SUP_RISK_IND.get_range3_low(3)),

Line 839: POA_PORTAL_SUP_RISK_IND.get_range3_low(3)),

835: POA_PORTAL_SUP_RISK_IND.get_range3_high(2)),
836: -1, avg(Price_Score),
837: 0, avg(Price_Score), -999)),
838: decode(sign(round(avg(Quality_Score)) -
839: POA_PORTAL_SUP_RISK_IND.get_range3_low(3)),
840: -1,-999,
841: 0, avg(Quality_Score),
842: 1, decode(sign(round(avg(Quality_Score)) -
843: POA_PORTAL_SUP_RISK_IND.get_range3_high(3)),

Line 843: POA_PORTAL_SUP_RISK_IND.get_range3_high(3)),

839: POA_PORTAL_SUP_RISK_IND.get_range3_low(3)),
840: -1,-999,
841: 0, avg(Quality_Score),
842: 1, decode(sign(round(avg(Quality_Score)) -
843: POA_PORTAL_SUP_RISK_IND.get_range3_high(3)),
844: -1, avg(Quality_Score),
845: 0, avg(Quality_Score), -999)),
846: decode(sign(round(avg(Delivery_Score)) -
847: POA_PORTAL_SUP_RISK_IND.get_range3_low(4)),

Line 847: POA_PORTAL_SUP_RISK_IND.get_range3_low(4)),

843: POA_PORTAL_SUP_RISK_IND.get_range3_high(3)),
844: -1, avg(Quality_Score),
845: 0, avg(Quality_Score), -999)),
846: decode(sign(round(avg(Delivery_Score)) -
847: POA_PORTAL_SUP_RISK_IND.get_range3_low(4)),
848: -1,-999,
849: 0, avg(Delivery_Score),
850: 1, decode(sign(round(avg(Delivery_Score)) -
851: POA_PORTAL_SUP_RISK_IND.get_range3_high(4)),

Line 851: POA_PORTAL_SUP_RISK_IND.get_range3_high(4)),

847: POA_PORTAL_SUP_RISK_IND.get_range3_low(4)),
848: -1,-999,
849: 0, avg(Delivery_Score),
850: 1, decode(sign(round(avg(Delivery_Score)) -
851: POA_PORTAL_SUP_RISK_IND.get_range3_high(4)),
852: -1, avg(Delivery_Score),
853: 0, avg(Delivery_Score), -999)),
854: decode(sign(round(avg(Survey_Score)) -
855: POA_PORTAL_SUP_RISK_IND.get_range3_low(5)),

Line 855: POA_PORTAL_SUP_RISK_IND.get_range3_low(5)),

851: POA_PORTAL_SUP_RISK_IND.get_range3_high(4)),
852: -1, avg(Delivery_Score),
853: 0, avg(Delivery_Score), -999)),
854: decode(sign(round(avg(Survey_Score)) -
855: POA_PORTAL_SUP_RISK_IND.get_range3_low(5)),
856: -1,-999,
857: 0, avg(Survey_Score),
858: 1, decode(sign(round(avg(Survey_Score)) -
859: POA_PORTAL_SUP_RISK_IND.get_range3_high(5)),

Line 859: POA_PORTAL_SUP_RISK_IND.get_range3_high(5)),

855: POA_PORTAL_SUP_RISK_IND.get_range3_low(5)),
856: -1,-999,
857: 0, avg(Survey_Score),
858: 1, decode(sign(round(avg(Survey_Score)) -
859: POA_PORTAL_SUP_RISK_IND.get_range3_high(5)),
860: -1, avg(Survey_Score),
861: 0, avg(Survey_Score), -999)),
862: sum(pod.amt_purchased_g)
863: from poa_edw_po_dist_f pod,