APPS.JAI_CMN_MTAX_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 367: FROM oe_order_headers_all

363: WHERE po_header_id = p_po_header_id AND release_num = p_release_no;
364:
365: CURSOR c_so_header( p_order_number IN NUMBER, p_org_id IN NUMBER) IS
366: SELECT header_id
367: FROM oe_order_headers_all
368: WHERE order_number = p_order_number
369: AND (p_org_id IS NULL OR org_id = p_org_id);
370:
371: CURSOR c_so_line( p_header_id IN NUMBER, p_line_no IN NUMBER) IS

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

815: ooha.transactional_curr_code currency_code, ooha.conversion_type_code, ooha.conversion_rate,
816: ooha.conversion_rate_date conversion_date,
817: ooha.ordered_date date_ordered, ooha.creation_date,
818: ooha.order_type_id, ooha.order_number document_no, oola.line_number
819: FROM oe_order_headers_all ooha, oe_order_lines_all oola, JAI_OM_OE_SO_LINES jisl
820: WHERE ooha.header_id = oola.header_id
821: AND oola.line_id = jisl.line_id
822: AND oola.open_flag = 'Y'
823: AND ((p_document_no is null) OR (p_document_no is not null and ooha.order_number = p_document_no ))