APPS.POA_SUPPERF_API_PKG dependencies on POA_BIS_SUPPLIER_PERFORMANCE_V

Line 546: FROM poa_bis_supplier_performance_v

542: SELECT supplier_id,
543: sum(quantity_rejected) /
544: decode(sum(nvl(quantity_received, 0)), 0, 1,
545: sum(nvl(quantity_received, 0))) defects
546: FROM poa_bis_supplier_performance_v
547: WHERE item_id = p_item
548: AND date_dimension between p_fdate and p_tdate
549: GROUP BY supplier_id
550: ORDER BY defects desc;

Line 561: FROM poa_bis_supplier_performance_v

557: sum(nvl(quantity_received_late, 0) +
558: nvl(quantity_received_early, 0) +
559: nvl(quantity_past_due, 0)) /
560: nvl(sum(quantity_ordered), 1) exceptions
561: FROM poa_bis_supplier_performance_v
562: WHERE item_id = p_item
563: AND date_dimension between p_fdate and p_tdate
564: GROUP BY supplier_id
565: ORDER BY exceptions desc;

Line 573: FROM poa_bis_supplier_performance_v

569:
570: OPEN v_cursor_blk FOR
571: SELECT supplier_id,
572: sum(quantity_purchased) volume
573: FROM poa_bis_supplier_performance_v
574: WHERE item_id = p_item
575: AND date_dimension between p_fdate and p_tdate
576: GROUP BY supplier_id
577: ORDER BY volume desc;

Line 586: FROM poa_bis_supplier_performance_v

582: OPEN v_cursor_blk FOR
583: SELECT supplier_id,
584: sum(quantity_ordered * purchase_price) /
585: nvl(sum(quantity_ordered), 1) price
586: FROM poa_bis_supplier_performance_v
587: WHERE item_id = p_item
588: AND date_dimension between p_fdate and p_tdate
589: GROUP BY supplier_id
590: ORDER BY price desc;

Line 598: FROM poa_bis_supplier_performance_v

594:
595: OPEN v_cursor_blk FOR
596: SELECT supplier_id,
597: sum(amount) amount
598: FROM poa_bis_supplier_performance_v
599: WHERE item_id = p_item
600: AND date_dimension between p_fdate and p_tdate
601: GROUP BY supplier_id
602: ORDER BY amount desc;

Line 612: FROM poa_bis_supplier_performance_v

608: SELECT supplier_id,
609: sum(quantity_rejected) /
610: decode(sum(nvl(quantity_received, 0)), 0, 1,
611: sum(nvl(quantity_received, 0))) defects
612: FROM poa_bis_supplier_performance_v
613: WHERE item_id = p_item
614: AND date_dimension between p_fdate and p_tdate
615: GROUP BY supplier_id
616: ORDER BY defects asc;

Line 627: FROM poa_bis_supplier_performance_v

623: sum(nvl(quantity_received_late, 0) +
624: nvl(quantity_received_early, 0) +
625: nvl(quantity_past_due, 0)) /
626: nvl(sum(quantity_ordered), 1) exceptions
627: FROM poa_bis_supplier_performance_v
628: WHERE item_id = p_item
629: AND date_dimension between p_fdate and p_tdate
630: GROUP BY supplier_id
631: ORDER BY exceptions asc;

Line 639: FROM poa_bis_supplier_performance_v

635:
636: OPEN v_cursor_blk FOR
637: SELECT supplier_id,
638: sum(quantity_purchased) volume
639: FROM poa_bis_supplier_performance_v
640: WHERE item_id = p_item
641: AND date_dimension between p_fdate and p_tdate
642: GROUP BY supplier_id
643: ORDER BY volume asc;

Line 652: FROM poa_bis_supplier_performance_v

648: OPEN v_cursor_blk FOR
649: SELECT supplier_id,
650: sum(quantity_ordered * purchase_price) /
651: nvl(sum(quantity_ordered), 1) price
652: FROM poa_bis_supplier_performance_v
653: WHERE item_id = p_item
654: AND date_dimension between p_fdate and p_tdate
655: GROUP BY supplier_id
656: ORDER BY price asc;

Line 664: FROM poa_bis_supplier_performance_v

660:
661: OPEN v_cursor_blk FOR
662: SELECT supplier_id,
663: sum(amount) amount
664: FROM poa_bis_supplier_performance_v
665: WHERE item_id = p_item
666: AND date_dimension between p_fdate and p_tdate
667: GROUP BY supplier_id
668: ORDER BY amount asc;