Sunday, March 29, 2015

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'

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect