Hi all,
In JDeveloper(10.1.3) I am trying to make a View Object with the following query:
SELECT dis.distribution_line_number,
dis.invoice_line_number,
dis.invoice_id,
dis.dist_code_combination_id,
dis.line_type_lookup_code,
dis.global_attribute10,
invoice_distribution_id,
dis.amount,
dis.description,
dis.accounting_date,
dis.posted_flag,
dis.set_of_books_id,
dis.request_id tax_code_id,
dis.org_id,
dis.match_status_flag,
phd.segment1,
dis.final_match_flag,
dis.period_name,
loc.receipt_required_flag,
plt.line_type,
dis.project_id,
dis.task_id,
ppa.name project_name,
ppa.segment1 project_number,
pts.task_name,
pts.task_number,
pla.line_num,
pla.unit_price,
pla.vendor_product_num,
msib.segment1 item_number,
pla.item_id,
loc.quantity,
loc.quantity_received,
loc.quantity_billed,
loc.quantity_shipped,
(loc.quantity * pla.unit_price) bedraginkooporder,
dis.attribute1 flex_field
FROM ap_invoice_distributions_all dis,
po_distributions_all pds,
po_headers_all phd,
po_line_locations_all loc,
po_lines_all pla,
po_line_types_tl plt,
pa_projects_all ppa,
pa_tasks pts,
mtl_system_items_b msib
WHERE dis.invoice_id = :invoice_id
AND dis.po_distribution_id = pds.po_distribution_id(+)
AND pds.line_location_id = loc.line_location_id(+)
AND dis.project_id = ppa.project_id(+)
AND pla.item_id = msib.inventory_item_id(+)
AND pla.org_id = msib.organization_id(+)
AND dis.task_id = pts.task_id(+)
AND pds.po_header_id = phd.po_header_id(+)
AND pds.po_header_id = pla.po_header_id(+)
AND pds.po_line_id = pla.po_line_id(+)
AND pla.line_type_id = plt.line_type_id(+)
AND((plt.LANGUAGE IS NULL) OR(plt.LANGUAGE = :language))
The problem is that I get the error:
ORA-00904: "DIS"."INVOICE_LINE_NUMBER": invalid identifier.
I execute the query on a Oracle R12 database. So that column is in the table. If I execute this query in SQLDeveloper it works fine.
What is going wrong in JDeveloper??