APPS.AHL_OSP_UTIL_PKG dependencies on AHL_OSP_ORDER_LINES

Line 600: FROM ahl_osp_order_lines

596: serial_number,
597: lot_number,
598: osp_order_id,
599: exchange_instance_id
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

Line 668: FROM ahl_osp_order_lines

664: serial_number,
665: lot_number,
666: osp_order_id,
667: exchange_instance_id
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

Line 722: FROM ahl_osp_order_lines

718: serial_number,
719: lot_number,
720: osp_order_id,
721: exchange_instance_id
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

Line 798: FROM ahl_osp_order_lines

794: serial_number,
795: lot_number,
796: osp_order_id,
797: exchange_instance_id
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