APPS.JAI_CMN_MTAX_PKG dependencies on OE_ORDER_LINES_ALL

Line 373: FROM oe_order_lines_all

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
372: SELECT line_id
373: FROM oe_order_lines_all
374: WHERE header_id = p_header_id AND line_number = p_line_no;
375:
376: CURSOR c_requisition_header( p_document_type IN VARCHAR2, p_requisition_no IN VARCHAR2, p_org_id IN NUMBER) IS
377: SELECT requisition_header_id

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 ))

Line 1216: oe_order_lines_all table . For a closed / Cancelled / SHIPPED order line the

1212: 10 18-05-2007 added by ssawant for bug 5604272
1213: Cursor " CURSOR c_main_so" is modified.
1214: It currently checks the status of a line thru a field called open_flag.
1215: The correct way is to check the flow_Status_code field in the
1216: oe_order_lines_all table . For a closed / Cancelled / SHIPPED order line the
1217: values would be CLOSED CANCELLED SHIPPED respectively. So "AND oola.flow_status_code not in
1218: ('CLOSED','CANCELLED','SHIPPED')" condition is added.
1219: 11. 05-Feb-2009 CSahoo for bug#8229357, File Version 120.5.12000000.4
1220: Issue: INDIA "MASS-TAX RECALCULATION" ENDS IN WARNING