CREATE OR REPLACE FORCE VIEW APPS.XXAP_INVLINE_INTERFACE_V

AS

   SELECT aii.org_id,

--##############################################################################--

--#                                                                            #--

--#   View Name : XXAP_INVLINE_INTERFACE_V                                     #--

--#                                                                            #--

--#  Description    :                                                         #--

--#   OFFICE MANDATORY AND REQUIED AP INVOICE AND LINES INTERFACE COLUMNS      #--

--#  Initial Verion       Created By                  Last_Update_Date         #--

--#  --------------       ----------                  ----------------         #--

--#      1.0              Santosh                      05-JAN-2016             #--

--#                                                                            #--

--##############################################################################--

          aii.request_id,

          aii.status,

          aii.invoice_type_lookup_code,

          aii.source,

          aii.invoice_id,

          aii.invoice_num,

          aii.invoice_date,

          aii.vendor_id,

          aii.vendor_site_id,

          aii.invoice_currency_code,

          aii.invoice_amount,

          aii.description,

          aii.exchange_rate,

          aii.terms_name,

          aii.attribute_category,

          aii.attribute2 dff_cpr_number,

          aii.attribute3 dff_manual_payment,

          aii.attribute4 dff_service_name,

          aii.attribute5 dff_number_of_instalments,

          aii.attribute6 dff_reason_for_refund,

          aii.attribute7 dff_اسم_الوكيل,

          aii.attribute8 dff_pensioner_cpr,

          aii.attribute9 dff_jv_reference,

          aii.creation_date,

          aii.created_by,

          aii.last_update_date,

          aii.last_updated_by,

          ali.invoice_id line_invoice_id,

          ali.invoice_line_id line_invoice_line_id,

          ali.line_number line_line_number,

          ali.line_type_lookup_code line_line_type_lookup_code,

          ali.amount line_amount,

          ali.description line_description,

          ali.dist_code_combination_id line_dist_code_combination_id,

          ali.distribution_set_id line_distribution_set_id,

          ali.distribution_set_name line_distribution_set_name,

          ali.dist_code_concatenated line_dist_code_concatenated,

          ali.attribute_category line_attribute_category,

          ali.attribute1 line_attribute1,

          ali.attribute2 line_attribute2,

          ali.attribute3 line_attribute3,

          ali.attribute4 line_attribute4,

          ali.attribute5 line_attribute5,

          ali.assets_tracking_flag line_assets_tracking_flag,

          ali.po_header_id line_po_header_id,

          ali.po_number line_po_number,

          ali.po_line_id line_po_line_id,

          ali.po_line_number line_po_line_number,

          ali.po_line_location_id line_po_line_location_id,

          ali.po_shipment_num line_po_shipment_num,

          ali.po_distribution_id line_po_distribution_id,

          ali.po_distribution_num line_po_distribution_num,

          ali.po_unit_of_measure line_po_unit_of_measure,

          ali.inventory_item_id line_inventory_item_id,

          ali.item_description line_item_description,

          ali.quantity_invoiced line_quantity_invoiced,

          ali.ship_to_location_code line_ship_to_location_code,

          ali.unit_price line_unit_price,

          ali.match_option line_match_option,

          ali.final_match_flag line_final_match_flag

     FROM ap_invoices_interface aii, ap_invoice_lines_interface ali

    WHERE aii.invoice_id = ali.invoice_id;