APPS.JAI_OM_TAX_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 3499: From oe_order_headers_all

3495: */
3496:
3497: CURSOR get_source_id IS
3498: Select order_source_id
3499: From oe_order_headers_all
3500: Where header_id = v_header_id;
3501:
3502: CURSOR Get_Order_Source_Type(P_Source_Document_Type_Id Number) is
3503: Select Name

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

3516: base.SOURCE_DOCUMENT_TYPE_ID, ja.assessable_value,
3517: NVL(head.org_id,0) org_id1, head.SOLD_TO_ORG_ID, head.SOURCE_DOCUMENT_ID hsdi, head.order_number,
3518: head.price_list_id, head.ORDER_CATEGORY_CODE, head.ORIG_SYS_DOCUMENT_REF, head.TRANSACTIONAL_CURR_CODE,
3519: head.conversion_type_code, head.conversion_rate, head.CONVERSION_RATE_DATE, nvl(head.ORDERED_DATE, head.creation_date) ordered_date
3520: FROM oe_order_headers_all head, oe_order_lines_all base, JAI_OM_OE_SO_LINES ja
3521: WHERE head.header_id = base.header_id
3522: and base.line_id = ja.line_id
3523: and base.OPEN_FLAG = 'Y'
3524: and base.line_category_code = 'ORDER'