DBA Data[Home] [Help]

APPS.OZF_RESALE_COMMON_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 469: FROM mtl_system_items_b msi

465: AND orsl.direct_customer_flag = 'T'
466: AND orsl.resale_batch_id = p_resale_batch_id
467: AND orsl.inventory_item_id IS NOT NULL
468: AND NOT EXISTS ( SELECT 1
469: FROM mtl_system_items_b msi
470: WHERE msi.inventory_item_id = orsl.inventory_item_id
471: AND msi.organization_id = G_ITEM_ORG_ID);
472:
473: BEGIN