APPS.QP_SOURCING_API_PUB dependencies on OE_ITEM_CUST_VOLS

Line 644: FROM oe_item_cust_vols

640: BEGIN
641:
642: SELECT period1_ordered_quantity, primary_uom_code
643: INTO x_item_quantity, l_puom
644: FROM oe_item_cust_vols
645: WHERE sold_to_org_id = p_cust_id
646: AND inventory_item_id = p_inventory_item_id;
647:
648: EXCEPTION

Line 698: FROM oe_item_cust_vols

694: BEGIN
695:
696: SELECT period2_ordered_quantity, primary_uom_code
697: INTO x_item_quantity, l_puom
698: FROM oe_item_cust_vols
699: WHERE sold_to_org_id = p_cust_id
700: AND inventory_item_id = p_inventory_item_id;
701:
702: EXCEPTION

Line 752: FROM oe_item_cust_vols

748: BEGIN
749:
750: SELECT period3_ordered_quantity, primary_uom_code
751: INTO x_item_quantity, l_puom
752: FROM oe_item_cust_vols
753: WHERE sold_to_org_id = p_cust_id
754: AND inventory_item_id = p_inventory_item_id;
755:
756: EXCEPTION

Line 807: FROM oe_item_cust_vols

803: BEGIN
804:
805: SELECT period1_total_amount
806: INTO x_amount
807: FROM oe_item_cust_vols
808: WHERE sold_to_org_id = p_cust_id
809: AND inventory_item_id = p_inventory_item_id;
810:
811: EXCEPTION

Line 892: FROM oe_item_cust_vols

888: BEGIN
889:
890: SELECT period2_total_amount
891: INTO x_amount
892: FROM oe_item_cust_vols
893: WHERE sold_to_org_id = p_cust_id
894: AND inventory_item_id = p_inventory_item_id;
895:
896: EXCEPTION

Line 977: FROM oe_item_cust_vols

973: BEGIN
974:
975: SELECT period3_total_amount
976: INTO x_amount
977: FROM oe_item_cust_vols
978: WHERE sold_to_org_id = p_cust_id
979: AND inventory_item_id = p_inventory_item_id;
980:
981: EXCEPTION