4933: AND ori.org_information_context = 'CLASS'
4934: AND ori.org_information1 = 'INV'
4935: AND ori.org_information2 = 'Y'
4936: AND EXISTS (SELECT 1
4937: FROM mtl_parameters
4938: WHERE master_organization_id = ood.organization_id)
4939: AND ood.organization_id = exe_int.inventory_org_id
4940:
4941: )
4954: AND ori.org_information_context = 'CLASS'
4955: AND ori.org_information1 = 'INV'
4956: AND ori.org_information2 = 'Y'
4957: AND EXISTS (SELECT 1
4958: FROM mtl_parameters
4959: WHERE master_organization_id = OOD.ORGANIZATION_ID
4960: )
4961: AND ood.organization_name = exe_int.inventory_org_name
4962: )
4983: AND ORI.org_information_context = 'CLASS'
4984: AND ORI.org_information1 = 'INV'
4985: AND ORI.org_information2 = 'Y'
4986: AND EXISTS (SELECT 1
4987: FROM mtl_parameters
4988: WHERE master_organization_id = OOD.ORGANIZATION_ID)
4989: AND OOD.ORGANIZATION_NAME = exe_int.Inventory_Org_name
4990: )
4991: WHERE record_status = G_RS_IN_PROCESS