SELECT iod.organization_code,
iod.organization_name,
iod.business_unit_name,
iod.business_unit_id,
iod.legal_entity,
xep.NAME legal_entity_name,
hla.location_code,
hla.location_name,
hla.internal_location_code ,
Concat(Concat(Concat(Concat(Concat(Concat( Concat(Concat(hla.address_line_1
|| ', ', Nvl2(hla.address_line_2, hla.address_line_2
|| ', ', hla.address_line_2)), Nvl2(hla.address_line_3, hla.address_line_3
|| ', ', hla.address_line_3)), Nvl2(hla.address_line_4, hla.address_line_4
|| ', ', hla.address_line_4)), Nvl2(hla.town_or_city, hla.town_or_city
|| ', ', hla.town_or_city)), Nvl2(hla.region_1, hla.region_1
|| ', ', hla.region_1)), Nvl2(hla.region_2, hla.region_2
|| ', ', hla.region_2)), Nvl2(hla.country, country
|| ', ', hla.country)), hla.postal_code) concatenated_address,
iod.inventory_enabled_flag,
iod.inventory_flag,
iod.distributed_organization_flag,
iod.profit_center_bu_id,
iod.mfg_plant_flag,
iod.contract_mfg_flag,
iod.eam_enabled_flag,
iod.timezone_code
FROM inv_organization_definitions_v iod,
hr_locations_all hla,
xle_entity_profiles xep
WHERE iod.location_id = hla.location_id
AND iod.legal_entity = xep.legal_entity_id
AND NVL(iod.disable_date, sysdate+1) > sysdate;
Tuesday, June 14, 2022
FA:SQL: Query to get inventory organization/inventory organization location and business unit and Legal entity
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.