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 216: FROM oe_order_headers_all

212:
213: CURSOR get_conv_detail_cur(p_order_header_id Number) IS
214: SELECT TRANSACTIONAL_CURR_CODE, conversion_type_code, conversion_rate,
215: NVL(conversion_rate_date,ordered_date) conversion_date
216: FROM oe_order_headers_all
217: WHERE header_id = p_order_header_id;
218:
219: /* Bug 5243532. Added by Lakshmi Gopalsami
220: * Removed the cursor set_of_books_cur as this

Line 232: from oe_order_headers_all

228:
229: -- Altered by Arun for 11i
230: cursor customer is
231: select SOLD_TO_ORG_ID
232: from oe_order_headers_all
233: where header_id in (select source_header_id
234: from wsh_delivery_details
235: where delivery_detail_id =pr_new.ref_line_id );
236: