[Home] [Help]
99: nvl(container_item_flag,'N'),
100: nvl(inventory_item_flag,'N')
101: FROM
102: mtl_system_items msi,
103: JAI_INV_ITM_SETUPS jmsi
104: WHERE msi.organization_id = jmsi.organization_id
105: AND msi.inventory_item_id = jmsi.inventory_item_id
106: AND jmsi.inventory_item_id = v_Inventory_Item_Id
107: AND jmsi.organization_id = v_organization_id;