APPS.AHL_OSP_UTIL_PKG dependencies on AHL_OSP_ORDERS_B

Line 604: SELECT order_type_code FROM ahl_osp_orders_b

600: FROM ahl_osp_order_lines
601: WHERE osp_order_line_id = p_osp_line_id;
602:
603: CURSOR get_osp_order_type_csr(c_osp_order_id IN NUMBER) IS
604: SELECT order_type_code FROM ahl_osp_orders_b
605: WHERE osp_order_id = c_osp_order_id;
606: */
607:
608: CURSOR get_instance_from_id_csr(c_instance_id IN NUMBER) IS

Line 672: SELECT order_type_code FROM ahl_osp_orders_b

668: FROM ahl_osp_order_lines
669: WHERE osp_order_line_id = p_osp_line_id;
670:
671: CURSOR get_osp_order_type_csr(c_osp_order_id IN NUMBER) IS
672: SELECT order_type_code FROM ahl_osp_orders_b
673: WHERE osp_order_id = c_osp_order_id;
674:
675: CURSOR get_instance_from_id_csr(c_instance_id IN NUMBER) IS
676: SELECT instance_number FROM csi_item_instances

Line 726: SELECT order_type_code from ahl_osp_orders_b

722: FROM ahl_osp_order_lines
723: WHERE osp_order_line_id = p_osp_line_id;
724:
725: CURSOR get_osp_order_type_csr(c_osp_order_id IN NUMBER) IS
726: SELECT order_type_code from ahl_osp_orders_b
727: WHERE osp_order_id = c_osp_order_id;
728:
729: CURSOR get_serial_from_instance_csr(c_instance_id IN NUMBER) IS
730: SELECT serial_number FROM csi_item_instances

Line 802: SELECT order_type_code from ahl_osp_orders_b

798: FROM ahl_osp_order_lines
799: WHERE osp_order_line_id = p_osp_line_id;
800:
801: CURSOR get_osp_order_type_csr(c_osp_order_id IN NUMBER) IS
802: SELECT order_type_code from ahl_osp_orders_b
803: WHERE osp_order_id = c_osp_order_id;
804:
805: CURSOR get_lot_num_from_instance_csr(c_instance_id IN NUMBER) IS
806: SELECT lot_number FROM csi_item_instances