SELECT (xlep.name || '(' || xlep.LEGAL_ENTITY_IDENTIFIER || ')'
|| CHR (10) ||hl.address_line_1
|| CASE WHEN hl.address_line_2 IS NOT NULL THEN CHR (10) || hl.address_line_2 END
|| CASE WHEN hl.address_line_3 IS NOT NULL THEN CHR (10) || hl.address_line_3 END
|| DECODE (
NVL (NVL (hl.town_or_city, hrlkp.meaning), hl.postal_code),
NULL,
NULL,
CHR (10)
)
|| DECODE (hl.town_or_city, NULL, NULL, hl.town_or_city || ', ')
|| DECODE (hrlkp.meaning, NULL, NULL, hrlkp.meaning || ' ')
|| DECODE (hl.postal_code, NULL, NULL, hl.postal_code)
|| DECODE (ftt.territory_short_name, NULL, NULL, CHR (10))
|| ftt.territory_short_name
|| DECODE (hl.telephone_number_1, NULL, NULL, CHR (10))
|| DECODE (hl.telephone_number_1,
NULL, NULL,
'Tel: ' || hl.telephone_number_1)
|| DECODE (hl.telephone_number_2, NULL, NULL, CHR (10))
|| DECODE (hl.telephone_number_2,
NULL, NULL,
'Fax: ' || hl.telephone_number_2)
|| DECODE (hl.attribute1, NULL, NULL, CHR (10))
|| DECODE (hl.attribute1, NULL, NULL, 'Email: ' || hl.attribute1))
FROM xle_entity_profiles xlep,
xle_registrations xlr,
hr_locations hl,
fnd_territories_tl ftt,
hr_lookups hrlkp
WHERE 1 = 1
AND xlep.legal_entity_id = xlr.source_id
AND xlr.source_table = 'XLE_ENTITY_PROFILES'
AND xlr.location_id = hl.location_id
AND hl.country = ftt.territory_code
AND hl.region_2 = hrlkp.lookup_code(+)
AND hrlkp.lookup_type(+) = 'US_STATE'
AND xlep.legal_entity_id = 29275--------Legal Entity Id
|| CHR (10) ||hl.address_line_1
|| CASE WHEN hl.address_line_2 IS NOT NULL THEN CHR (10) || hl.address_line_2 END
|| CASE WHEN hl.address_line_3 IS NOT NULL THEN CHR (10) || hl.address_line_3 END
|| DECODE (
NVL (NVL (hl.town_or_city, hrlkp.meaning), hl.postal_code),
NULL,
NULL,
CHR (10)
)
|| DECODE (hl.town_or_city, NULL, NULL, hl.town_or_city || ', ')
|| DECODE (hrlkp.meaning, NULL, NULL, hrlkp.meaning || ' ')
|| DECODE (hl.postal_code, NULL, NULL, hl.postal_code)
|| DECODE (ftt.territory_short_name, NULL, NULL, CHR (10))
|| ftt.territory_short_name
|| DECODE (hl.telephone_number_1, NULL, NULL, CHR (10))
|| DECODE (hl.telephone_number_1,
NULL, NULL,
'Tel: ' || hl.telephone_number_1)
|| DECODE (hl.telephone_number_2, NULL, NULL, CHR (10))
|| DECODE (hl.telephone_number_2,
NULL, NULL,
'Fax: ' || hl.telephone_number_2)
|| DECODE (hl.attribute1, NULL, NULL, CHR (10))
|| DECODE (hl.attribute1, NULL, NULL, 'Email: ' || hl.attribute1))
FROM xle_entity_profiles xlep,
xle_registrations xlr,
hr_locations hl,
fnd_territories_tl ftt,
hr_lookups hrlkp
WHERE 1 = 1
AND xlep.legal_entity_id = xlr.source_id
AND xlr.source_table = 'XLE_ENTITY_PROFILES'
AND xlr.location_id = hl.location_id
AND hl.country = ftt.territory_code
AND hl.region_2 = hrlkp.lookup_code(+)
AND hrlkp.lookup_type(+) = 'US_STATE'
AND xlep.legal_entity_id = 29275--------Legal Entity Id
We have sell some products of different custom boxes.it is very useful and very low price please visits this site thanks and please share this post with your friends. Legal Entity Identifier Number
ReplyDeleteMuha Meds how to use – Simply inhale from the mouthpiece to activate. Muha Meds Disposable
ReplyDeleteA legal entity identifier is a globally recognized 20-character code used to identify companies involved in financial transactions. It is required for certain RBI-regulated activities, high-value banking transactions, and international payments. The legal entity identifier improves transparency and helps banks and regulators track entities accurately. Once issued, the LEI must be renewed periodically to remain active and valid.
ReplyDelete