APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on OE_ORDER_SOURCES

Line 304: FROM oe_order_sources

300:
301: --2001/10/01 Anuradha Parthasarathy
302: CURSOR get_order_source_type(p_source_document_type_id NUMBER) IS
303: SELECT name
304: FROM oe_order_sources
305: WHERE order_source_id = p_source_document_type_id;
306:
307: CURSOR get_copy_order_line (p_header_Id NUMBER, p_Line_Id NUMBER) IS
308: SELECT inventory_item_id, unit_code, quantity,

Line 3547: FROM oe_order_sources

3543:
3544: /* Added by Brathod for bug# 4244829 */
3545: CURSOR get_order_source_type(cp_source_document_type_id NUMBER) IS
3546: SELECT name
3547: FROM oe_order_sources
3548: WHERE order_source_id = cp_source_document_type_id;
3549:
3550: V_Order_Source_Type OE_ORDER_SOURCES.NAME%TYPE;
3551: /* End Bug# 4244829 */

Line 3550: V_Order_Source_Type OE_ORDER_SOURCES.NAME%TYPE;

3546: SELECT name
3547: FROM oe_order_sources
3548: WHERE order_source_id = cp_source_document_type_id;
3549:
3550: V_Order_Source_Type OE_ORDER_SOURCES.NAME%TYPE;
3551: /* End Bug# 4244829 */
3552:
3553: /* Added for DFF Elimination by Ramananda. Bug#4348749 */
3554: cursor c_rma_line_dtls(cp_rma_line_id in number) is