DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on MTL_SYSTEM_ITEMS

Line 392: mtl_system_items msi

388: p_cnt_flag IN VARCHAR2) is
389: select 'N'
390: from wsh_delivery_assignments_v wda,
391: wsh_delivery_details wdd,
392: mtl_system_items msi
393: where wda.delivery_detail_id = wdd.delivery_detail_id
394: and wdd.inventory_item_id = msi.inventory_item_id
395: and wdd.organization_id = msi.organization_id
396: and nvl(msi.shippable_item_flag,'Y') = 'N'