VIEW for ap_invoice_lines_interface Mandatory and Requied columns as APPS.AP_INVOICE_LINES_INTERFACE_V

CREATE OR REPLACE FORCE VIEW APPS.AP_INVOICE_LINES_INTERFACE_V

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

--#                                                                            #--

--#   View Name : APPS.AP_INVOICE_LINES_INTERFACE_V                            #--

--#                                                                            #--

--#  Description    :                                                         #--

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

--#  Initial Verion       Created By                  Last_Update_Date         #--

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

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

--#                                                                            #--

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

AS

   SELECT org_id,

          invoice_id,

          invoice_line_id,

          line_number,

          line_type_lookup_code,

          amount,

          description,

          dist_code_combination_id,

          accounting_date,

          distribution_set_id,

          distribution_set_name,

          dist_code_concatenated,

          attribute_category,

          attribute1,

          attribute2,

          attribute3,

          attribute4,

          attribute5,

          assets_tracking_flag,

          po_header_id,

          po_number,

          po_line_id,

          po_line_number,

          po_line_location_id,

          po_shipment_num,

          po_distribution_id,

          po_distribution_num,

          po_unit_of_measure,

          inventory_item_id,

          item_description,

          quantity_invoiced,

          ship_to_location_code,

          unit_price,

          match_option,

          final_match_flag,

          created_by,

          creation_date,

          last_updated_by,

          last_update_date,

          last_update_login,

          line_group_number

     FROM ap_invoice_lines_interface;