DBA Data[Home] [Help]

APPS.CS_STD dependencies on MTL_SYSTEM_ITEMS

Line 416: from mtl_system_items mtl

412: --
413: and exists
414: (
415: select 'Component is a Warranty'
416: from mtl_system_items mtl
417: where mtl.organization_id = p_organization_id
418: and mtl.inventory_item_id = bic.component_item_id
419: and mtl.vendor_warranty_flag = 'Y'
420: )