Oracle Receivable Invoice details view ( Transaction Workbench )

Oracle Receivable Invoice  details view ( Transaction Workbench )  

CREATE OR REPLACE FORCE VIEW APPS.XXALLARINVOICECHECK

AS

   SELECT --##############################################################################--

 --#                                                                            #--

 --#   Object Name :  XXALLARINVOICECHECK   VIEW                                #--

 --#                                                                            #--

 --#   Description    : AR Receivable Invoice details                           #--

 --#                                                                            #--

 --#  Initial Verion       Created By                  Last_Update_Date         #--

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

 --#      1.0              Santosh                      09-AUG-2016             #--

 --#                                                                            #--

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

         ac.customer_name Customer_Name,

         rtl.trx_number Trx_No,

         rtl.trx_date Trx_Dt,

         rgd.gl_date GL_Dt,

         rct.line_number LINE_NO,

         rct.DESCRIPTION,

         rct.quantity_invoiced LINE_QTY,

         rct.unit_selling_price UNIT_SP,

         (rct.revenue_amount) Line_Amt,

         (rct.extended_amount) Dist_Amt,

         (SELECT concatenated_segments

            FROM apps.gl_code_combinations_kfv

           WHERE code_combination_id = rgd.code_combination_id)

            Acccount

    FROM apps.ra_customer_trx_all rtl,

         apps.ar_customers ac,

         apps.ra_customer_trx_lines_all rct,

         apps.ra_cust_trx_line_gl_dist_all rgd

   WHERE     1 = 1

         AND ac.customer_id = rtl.bill_to_customer_id

         AND rct.customer_trx_id = rtl.customer_trx_id

         AND rct.customer_trx_line_id = rgd.customer_trx_line_id

         AND rtl.customer_trx_id = rgd.customer_trx_id;