VIEW for ap_invoices_interface mandatory and requied columns as APPS.AP_INVOICES_INTERFACE_V

CREATE OR REPLACE FORCE VIEW APPS.AP_INVOICES_INTERFACE_V

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

--#                                                                            #--

--#   View Name : APPS.AP_INVOICES_INTERFACE_V                                 #--

--#                                                                            #--

--#  Description    :                                                          #--

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

--#  Initial Verion       Created By                  Last_Update_Date         #--

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

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

--#                                                                            #--

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

AS

   SELECT org_id,

          request_id,

          status,

          invoice_type_lookup_code,

          source,

          invoice_id,

          invoice_num,

          invoice_date,

          vendor_id,

          vendor_site_id,

          invoice_currency_code,

          invoice_amount,

          description,

          exchange_rate,

          terms_name,

          attribute_category,

          attribute10 dff_type_of_payment,

          --attribute1,

          attribute2 dff_cpr_number,

          attribute3 dff_manual_payment,

          attribute4 dff_service_name,

          attribute5 dff_number_of_instalments,

          attribute6 dff_reason_for_refund,

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

          attribute8 dff_pensioner_cpr,

          attribute9 dff_jv_reference,

          creation_date,

          created_by,

          last_update_date,

          last_updated_by,

          last_update_login,

          gl_date,

          po_number,

          vendor_num,

          vendor_name,

          vendor_site_code,

          exchange_rate_type,

          terms_id,

          doc_category_code,

          voucher_num,

          payment_method_lookup_code,

          pay_group_lookup_code,

          GROUP_ID

     /*###########################################

     -----Generic view for ap_invoice_interface

     SELECT org_id,

            status,

            invoice_type_lookup_code,

            source,

            request_id,

            invoice_id,

            invoice_num,

            invoice_date,

            gl_date,

            po_number,

            vendor_id,

            vendor_site_id,

            vendor_num,

            vendor_name,

            vendor_site_code,

            invoice_currency_code,

            invoice_amount,

            description,

            exchange_rate,

            exchange_rate_type,

            terms_id,

            terms_name,

            creation_date,

            created_by,

            last_update_date,

            last_updated_by,

            last_update_login,

            attribute_category,

            attribute1,

            attribute2,

            attribute3,

            attribute4,

            attribute5,

            attribute6,

            attribute7,

            attribute8,

            attribute9,

            attribute10,

            doc_category_code,

            voucher_num,

            payment_method_lookup_code,

            pay_group_lookup_code,

            GROUP_ID

       FROM apps.ap_invoices_interface

     ###########################################*/

     FROM apps.ap_invoices_interface;