APPS.JAI_CMN_MTAX_PKG dependencies on OE_ORDER_LINES_ALL

Line 332: FROM oe_order_lines_all

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
331: SELECT line_id
332: FROM oe_order_lines_all
333: WHERE header_id = p_header_id AND line_number = p_line_no;
334:
335: CURSOR c_requisition_header( p_document_type IN VARCHAR2, p_requisition_no IN VARCHAR2, p_org_id IN NUMBER) IS
336: SELECT requisition_header_id

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

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

882: 10 18-05-2007 added by ssawant for bug 5604272
883: Cursor " CURSOR c_main_so" is modified.
884: It currently checks the status of a line thru a field called open_flag.
885: The correct way is to check the flow_Status_code field in the
886: oe_order_lines_all table . For a closed / Cancelled / SHIPPED order line the
887: values would be CLOSED CANCELLED SHIPPED respectively. So "AND oola.flow_status_code not in
888: ('CLOSED','CANCELLED','SHIPPED')" condition is added.
889:
890: ===============================================================================