APPS.OZF_RESALE_COMMON_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 483: FROM mtl_system_items_b msi

479: AND orsl.direct_customer_flag = 'T'
480: AND orsl.resale_batch_id = p_resale_batch_id
481: AND orsl.inventory_item_id IS NOT NULL
482: AND NOT EXISTS ( SELECT 1
483: FROM mtl_system_items_b msi
484: WHERE msi.inventory_item_id = orsl.inventory_item_id
485: AND msi.organization_id = G_ITEM_ORG_ID);
486:
487: BEGIN