APPS.JAI_OM_TAX_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 2447: From oe_order_headers_all

2443: */
2444:
2445: CURSOR get_source_id IS
2446: Select order_source_id
2447: From oe_order_headers_all
2448: Where header_id = v_header_id;
2449:
2450: CURSOR Get_Order_Source_Type(P_Source_Document_Type_Id Number) is
2451: Select Name

Line 2468: FROM oe_order_headers_all head, oe_order_lines_all base, JAI_OM_OE_SO_LINES ja

2464: base.SOURCE_DOCUMENT_TYPE_ID, ja.assessable_value,
2465: NVL(head.org_id,0) org_id1, head.SOLD_TO_ORG_ID, head.SOURCE_DOCUMENT_ID hsdi, head.order_number,
2466: head.price_list_id, head.ORDER_CATEGORY_CODE, head.ORIG_SYS_DOCUMENT_REF, head.TRANSACTIONAL_CURR_CODE,
2467: head.conversion_type_code, head.conversion_rate, head.CONVERSION_RATE_DATE, nvl(head.ORDERED_DATE, head.creation_date) ordered_date
2468: FROM oe_order_headers_all head, oe_order_lines_all base, JAI_OM_OE_SO_LINES ja
2469: WHERE head.header_id = base.header_id
2470: and base.line_id = ja.line_id
2471: and base.OPEN_FLAG = 'Y'
2472: and base.line_category_code = 'ORDER'