Oracle EBS Latam Tax-Vat Document Letter Assignment

Oracle EBS Latam Tax-Vat Document Letter Assignment

Tables:-
JL_AR_AR_DOC_LETTER_ALL

SQL Example:-

SELECT
hou.name  "Operating Unit"
,vlkp1.meaning  "Organization Condition"
,vlkp2.meaning  "Organization Value"
,clkp1.meaning  "Contributor Condition"
,clkp2.meaning  "Contributor Value"
,doc.document_letter  "Document Letter"
,doc.start_date_active  "From Date"
,doc.end_date_active  "To Date"
FROM
JL_AR_AR_DOC_LETTER_ALL doc
,FND_LOOKUPS vlkp1
,FND_LOOKUPS vlkp2
,FND_LOOKUPS clkp1
,FND_LOOKUPS clkp2
,fnd_lookups dlkp
,HR_OPERATING_UNITS hou
WHERE 1=1
AND doc.org_tax_attribute_name = vlkp1.lookup_code
AND vlkp1.lookup_type = 'ORGANIZATION_ATTRIBUTE'
AND doc.org_tax_attribute_value  = vlkp2.lookup_code
AND vlkp2.lookup_type = 'JLZZ_AR_TX_ATTR_VALUE'
AND doc.con_tax_attribute_name   = clkp1.lookup_code
AND clkp1.lookup_type = 'CONTRIBUTOR_ATTRIBUTE'
AND doc.con_tax_attribute_value  = clkp2.lookup_code
AND clkp2.lookup_type = 'JLZZ_AR_TX_ATTR_VALUE'
AND doc.document_letter = dlkp.lookup_code
AND dlkp.lookup_type = 'JLAR_DOCUMENT_LETTER'
AND doc.org_id = hou.organization_id
AND hou.short_code= '&&';