Oracle AR Invoice Tax Details

SELECT DISTINCT

    I.CUSTOMER_NAME,

    A.TRX_NUMBER,

    E.TAX_NAME,

    D.TAX_AMOUNT,

    (H.SEGMENT1

    ||'.'||H.SEGMENT2    

    ||'.'||H.SEGMENT3    

    ||'.'||H.SEGMENT4    

    ||'.'||H.SEGMENT5    

    ||'.'||H.SEGMENT6    

    ||'.'||H.SEGMENT7    

    ||'.'||H.SEGMENT8    

    ||'.'||H.SEGMENT9    

    ||'.'||h.SEGMENT10) Account_Code

  FROM

    RA_CUSTOMER_TRX_ALL A,

    RA_CUSTOMER_TRX_LINES_ALL B,

    JAI_AR_TRX_LINES C,

    JAI_AR_TRX_TAX_LINES D,

    JAI_CMN_TAXES_ALL E,

    JAI_AR_TRXS F,

    JAI_AR_TRX_LINES G,

    GL_CODE_COMBINATIONS H,

    AR_CUSTOMERS i

  WHERE 1                       =1

  AND A.CUSTOMER_TRX_ID         =B.CUSTOMER_TRX_ID

  AND A.CUSTOMER_TRX_ID         =C.CUSTOMER_TRX_ID

  AND B.CUSTOMER_TRX_LINE_ID    =C.CUSTOMER_TRX_LINE_ID

  AND D.LINK_TO_CUST_TRX_LINE_ID=B.CUSTOMER_TRX_LINE_ID

  AND E.TAX_ID                  =D.TAX_ID

  AND B.CUSTOMER_TRX_ID         =F.CUSTOMER_TRX_ID

  AND G.CUSTOMER_TRX_ID         =F.CUSTOMER_TRX_ID

  AND E.TAX_ACCOUNT_ID          =H.CODE_COMBINATION_ID(+)

  AND I.CUSTOMER_ID             = A.BILL_TO_CUSTOMER_ID

  AND A.TRX_NUMBER              ='562233'