APPS.QP_SOURCING_API_PUB dependencies on OE_ITEM_CUST_VOLS

Line 636: FROM oe_item_cust_vols

632: BEGIN
633:
634: SELECT period1_ordered_quantity, primary_uom_code
635: INTO x_item_quantity, l_puom
636: FROM oe_item_cust_vols
637: WHERE sold_to_org_id = p_cust_id
638: AND inventory_item_id = p_inventory_item_id;
639:
640: EXCEPTION

Line 690: FROM oe_item_cust_vols

686: BEGIN
687:
688: SELECT period2_ordered_quantity, primary_uom_code
689: INTO x_item_quantity, l_puom
690: FROM oe_item_cust_vols
691: WHERE sold_to_org_id = p_cust_id
692: AND inventory_item_id = p_inventory_item_id;
693:
694: EXCEPTION

Line 744: FROM oe_item_cust_vols

740: BEGIN
741:
742: SELECT period3_ordered_quantity, primary_uom_code
743: INTO x_item_quantity, l_puom
744: FROM oe_item_cust_vols
745: WHERE sold_to_org_id = p_cust_id
746: AND inventory_item_id = p_inventory_item_id;
747:
748: EXCEPTION

Line 799: FROM oe_item_cust_vols

795: BEGIN
796:
797: SELECT period1_total_amount
798: INTO x_amount
799: FROM oe_item_cust_vols
800: WHERE sold_to_org_id = p_cust_id
801: AND inventory_item_id = p_inventory_item_id;
802:
803: EXCEPTION

Line 884: FROM oe_item_cust_vols

880: BEGIN
881:
882: SELECT period2_total_amount
883: INTO x_amount
884: FROM oe_item_cust_vols
885: WHERE sold_to_org_id = p_cust_id
886: AND inventory_item_id = p_inventory_item_id;
887:
888: EXCEPTION

Line 969: FROM oe_item_cust_vols

965: BEGIN
966:
967: SELECT period3_total_amount
968: INTO x_amount
969: FROM oe_item_cust_vols
970: WHERE sold_to_org_id = p_cust_id
971: AND inventory_item_id = p_inventory_item_id;
972:
973: EXCEPTION