VIEW: APPS.AR_TRX_TAX_L_VL

Source

View Text - Preformatted

SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ vtlf.printed_tax_name tax_printed_name ,l.event_id event_id ,l.line_number line_number ,vtlf.language language ,l.ledger_id ledger_id FROM ar_vat_tax_all_tl vtlf ,ar_xla_lines_extract l WHERE l.tax_code_id = vtlf.vat_tax_id (+) AND l.level_flag = 'L' AND l.org_id = vtlf.org_id (+)

View Text - HTML Formatted

SELECT /*+ INDEX(L AR_XLA_LINES_EXTRACT_N1) */ VTLF.PRINTED_TAX_NAME TAX_PRINTED_NAME
, L.EVENT_ID EVENT_ID
, L.LINE_NUMBER LINE_NUMBER
, VTLF.LANGUAGE LANGUAGE
, L.LEDGER_ID LEDGER_ID
FROM AR_VAT_TAX_ALL_TL VTLF
, AR_XLA_LINES_EXTRACT L
WHERE L.TAX_CODE_ID = VTLF.VAT_TAX_ID (+)
AND L.LEVEL_FLAG = 'L'
AND L.ORG_ID = VTLF.ORG_ID (+)