APPS.JAI_CMN_MTAX_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 326: FROM oe_order_headers_all

322: WHERE po_header_id = p_po_header_id AND release_num = p_release_no;
323:
324: CURSOR c_so_header( p_order_number IN NUMBER, p_org_id IN NUMBER) IS
325: SELECT header_id
326: FROM oe_order_headers_all
327: WHERE order_number = p_order_number
328: AND (p_org_id IS NULL OR org_id = p_org_id);
329:
330: CURSOR c_so_line( p_header_id IN NUMBER, p_line_no IN NUMBER) IS

Line 682: FROM oe_order_headers_all ooha, oe_order_lines_all oola, JAI_OM_OE_SO_LINES jisl

678: ooha.transactional_curr_code currency_code, ooha.conversion_type_code, ooha.conversion_rate,
679: ooha.conversion_rate_date conversion_date,
680: ooha.ordered_date date_ordered, ooha.creation_date,
681: ooha.order_type_id, ooha.order_number document_no, oola.line_number
682: FROM oe_order_headers_all ooha, oe_order_lines_all oola, JAI_OM_OE_SO_LINES jisl
683: WHERE ooha.header_id = oola.header_id
684: AND oola.line_id = jisl.line_id
685: AND oola.open_flag = 'Y'
686: AND ((p_document_no is null) OR (p_document_no is not null and ooha.order_number = p_document_no ))