VIEW: APPS.ARFV_TAXES

Source

View Text - Preformatted

SELECT /* UNIQUE ATTRIBUTES */ CTL.CUSTOMER_TRX_LINE_ID , /* REGULAR ATTRIBUTES*/ ASCTL.EXTENDED_AMOUNT , CTL.EXTENDED_AMOUNT , '_LA:CTL.REASON_CODE:AR_LOOKUPS:INVOICING_REASON:MEANING' , CTL.TAX_RATE , CTL.TAX_EXEMPT_NUMBER , '_LA:CTL.TAX_EXEMPT_REASON_CODE:AR_LOOKUPS:TAX_REASON:MEANING' , '_LA:CTL.AMOUNT_INCLUDES_TAX_FLAG:AR_LOOKUPS:YES/NO:MEANING' , /* RESOLVED FK RESOLUTIONS */ CT.TRX_NUMBER, CT.TRX_DATE , CT.COMPLETE_FLAG , CRCT.TRX_NUMBER , CRCTL.LINE_NUMBER , COCT.TRX_NUMBER , COCTL.LINE_NUMBER , ASCTL.LINE_NUMBER , AOU.NAME , '_DF:AR:RA_CUSTOMER_TRX_LINES:CTL' , '_DF:AR:RA_INTERFACE_LINES:CTL' , '_DF:JG:JG_RA_CUSTOMER_TRX_LINES:CTL' , /* IDS */ CTL.CUSTOMER_TRX_ID , CTL.PREVIOUS_CUSTOMER_TRX_ID , CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID , CTL.INITIAL_CUSTOMER_TRX_LINE_ID , CTL.LINK_TO_CUST_TRX_LINE_ID , CTL.ORG_ID , /* WHO COLUMNS */ CTL.LAST_UPDATE_DATE , CTL.LAST_UPDATED_BY , CTL.CREATION_DATE , CTL.CREATED_BY FROM RA_CUSTOMER_TRX_LINES_ALL CTL, RA_CUSTOMER_TRX_ALL CT, RA_CUSTOMER_TRX_ALL CRCT, RA_CUSTOMER_TRX_LINES_ALL CRCTL, RA_CUSTOMER_TRX_ALL COCT, RA_CUSTOMER_TRX_LINES_ALL COCTL, RA_CUSTOMER_TRX_LINES_ALL ASCTL, HR_ALL_ORGANIZATION_UNITS AOU WHERE CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID AND CTL.LINE_TYPE = 'TAX' AND CT.PREVIOUS_CUSTOMER_TRX_ID = CRCT.CUSTOMER_TRX_ID (+) AND CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID = CRCTL.CUSTOMER_TRX_LINE_ID (+) AND CTL.INITIAL_CUSTOMER_TRX_LINE_ID = COCTL.CUSTOMER_TRX_LINE_ID (+) AND CT.INITIAL_CUSTOMER_TRX_ID = COCT.CUSTOMER_TRX_ID (+) AND CTL.LINK_TO_CUST_TRX_LINE_ID = ASCTL.CUSTOMER_TRX_LINE_ID AND CT.ORG_ID = AOU.ORGANIZATION_ID (+)

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ CTL.CUSTOMER_TRX_LINE_ID
, /* REGULAR ATTRIBUTES*/ ASCTL.EXTENDED_AMOUNT
, CTL.EXTENDED_AMOUNT
, '_LA:CTL.REASON_CODE:AR_LOOKUPS:INVOICING_REASON:MEANING'
, CTL.TAX_RATE
, CTL.TAX_EXEMPT_NUMBER
, '_LA:CTL.TAX_EXEMPT_REASON_CODE:AR_LOOKUPS:TAX_REASON:MEANING'
, '_LA:CTL.AMOUNT_INCLUDES_TAX_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, /* RESOLVED FK RESOLUTIONS */ CT.TRX_NUMBER
, CT.TRX_DATE
, CT.COMPLETE_FLAG
, CRCT.TRX_NUMBER
, CRCTL.LINE_NUMBER
, COCT.TRX_NUMBER
, COCTL.LINE_NUMBER
, ASCTL.LINE_NUMBER
, AOU.NAME
, '_DF:AR:RA_CUSTOMER_TRX_LINES:CTL'
, '_DF:AR:RA_INTERFACE_LINES:CTL'
, '_DF:JG:JG_RA_CUSTOMER_TRX_LINES:CTL'
, /* IDS */ CTL.CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID
, CTL.INITIAL_CUSTOMER_TRX_LINE_ID
, CTL.LINK_TO_CUST_TRX_LINE_ID
, CTL.ORG_ID
, /* WHO COLUMNS */ CTL.LAST_UPDATE_DATE
, CTL.LAST_UPDATED_BY
, CTL.CREATION_DATE
, CTL.CREATED_BY
FROM RA_CUSTOMER_TRX_LINES_ALL CTL
, RA_CUSTOMER_TRX_ALL CT
, RA_CUSTOMER_TRX_ALL CRCT
, RA_CUSTOMER_TRX_LINES_ALL CRCTL
, RA_CUSTOMER_TRX_ALL COCT
, RA_CUSTOMER_TRX_LINES_ALL COCTL
, RA_CUSTOMER_TRX_LINES_ALL ASCTL
, HR_ALL_ORGANIZATION_UNITS AOU
WHERE CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND CTL.LINE_TYPE = 'TAX'
AND CT.PREVIOUS_CUSTOMER_TRX_ID = CRCT.CUSTOMER_TRX_ID (+)
AND CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID = CRCTL.CUSTOMER_TRX_LINE_ID (+)
AND CTL.INITIAL_CUSTOMER_TRX_LINE_ID = COCTL.CUSTOMER_TRX_LINE_ID (+)
AND CT.INITIAL_CUSTOMER_TRX_ID = COCT.CUSTOMER_TRX_ID (+)
AND CTL.LINK_TO_CUST_TRX_LINE_ID = ASCTL.CUSTOMER_TRX_LINE_ID
AND CT.ORG_ID = AOU.ORGANIZATION_ID (+)