APPS.JAI_JMCR_TRIGGER_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 56: FROM oe_order_headers_all

52:
53: CURSOR get_conv_detail_cur(p_order_header_id Number) IS
54: SELECT TRANSACTIONAL_CURR_CODE, conversion_type_code, conversion_rate,
55: NVL(conversion_rate_date,ordered_date) conversion_date
56: FROM oe_order_headers_all
57: WHERE header_id = p_order_header_id;
58: /* Bug 5243532. Added by Lakshmi Gopalsami
59: * Removed the cursor set_of_books_cur as this
60: * is not used anywhere.

Line 224: FROM oe_order_headers_all

220:
221: CURSOR get_conv_detail_cur(p_order_header_id Number) IS
222: SELECT TRANSACTIONAL_CURR_CODE, conversion_type_code, conversion_rate,
223: NVL(conversion_rate_date,ordered_date) conversion_date
224: FROM oe_order_headers_all
225: WHERE header_id = p_order_header_id;
226:
227: /* Bug 5243532. Added by Lakshmi Gopalsami
228: * Removed the cursor set_of_books_cur as this

Line 240: from oe_order_headers_all

236:
237: -- Altered by Arun for 11i
238: cursor customer is
239: select SOLD_TO_ORG_ID
240: from oe_order_headers_all
241: where header_id in (select source_header_id
242: from wsh_delivery_details
243: where delivery_detail_id =pr_new.ref_line_id );
244: