APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on OE_ORDER_SOURCES

Line 323: FROM oe_order_sources

319:
320: --2001/10/01 Anuradha Parthasarathy
321: CURSOR get_order_source_type(p_source_document_type_id NUMBER) IS
322: SELECT name
323: FROM oe_order_sources
324: WHERE order_source_id = p_source_document_type_id;
325:
326: CURSOR get_copy_order_line (p_header_Id NUMBER, p_Line_Id NUMBER) IS
327: SELECT inventory_item_id, unit_code, quantity,

Line 5678: FROM oe_order_sources

5674:
5675: /* Added by Brathod for bug# 4244829 */
5676: CURSOR get_order_source_type(cp_source_document_type_id NUMBER) IS
5677: SELECT name
5678: FROM oe_order_sources
5679: WHERE order_source_id = cp_source_document_type_id;
5680:
5681: V_Order_Source_Type OE_ORDER_SOURCES.NAME%TYPE;
5682: /* End Bug# 4244829 */

Line 5681: V_Order_Source_Type OE_ORDER_SOURCES.NAME%TYPE;

5677: SELECT name
5678: FROM oe_order_sources
5679: WHERE order_source_id = cp_source_document_type_id;
5680:
5681: V_Order_Source_Type OE_ORDER_SOURCES.NAME%TYPE;
5682: /* End Bug# 4244829 */
5683:
5684: /* Added for DFF Elimination by Ramananda. Bug#4348749 */
5685: cursor c_rma_line_dtls(cp_rma_line_id in number) is